怎么才能简化我的这个公式呢?太长了.=IF(B2="A6HG30","E6",IF(B2="A6HG31","B2",IF(B2="A1HG30","D1",IF(B2="A1HG31","D1",IF(B2="A1MG31","D2",IF(B2="A6SG30","A3",IF(B2="A6SG31","A3",IF(B2="F1CG31","C1",IF(B2="F4CG31","B3",IF(B2="F8CG30","D3"

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/07 06:55:16
怎么才能简化我的这个公式呢?太长了.=IF(B2=

怎么才能简化我的这个公式呢?太长了.=IF(B2="A6HG30","E6",IF(B2="A6HG31","B2",IF(B2="A1HG30","D1",IF(B2="A1HG31","D1",IF(B2="A1MG31","D2",IF(B2="A6SG30","A3",IF(B2="A6SG31","A3",IF(B2="F1CG31","C1",IF(B2="F4CG31","B3",IF(B2="F8CG30","D3"
怎么才能简化我的这个公式呢?太长了.
=IF(B2="A6HG30","E6",IF(B2="A6HG31","B2",IF(B2="A1HG30","D1",IF(B2="A1HG31","D1",IF(B2="A1MG31","D2",IF(B2="A6SG30","A3",IF(B2="A6SG31","A3",IF(B2="F1CG31","C1",IF(B2="F4CG31","B3",IF(B2="F8CG30","D3",IF(B2="S2HG31","C3",IF(B2="S2HG30","B3",IF(B2="S4HG31","B3",IF(B2="S4HG30","B3",IF(B2="S4HG40","B3",IF(B2="S8HG30","D4",IF(B2="S9HG31","B1",IF(B2="S9HG30","B1",IF(B2="S9HG40","D4",IF(B2="SF1870","B3",IF(B2="W1HG30","D4")))))))))))))))))))))
另个,我这个公式是输入在H2的,要怎么才能让B2没有输入信息或者信息不满足这里面的条件的情况下,让H2显示空白呢?.

怎么才能简化我的这个公式呢?太长了.=IF(B2="A6HG30","E6",IF(B2="A6HG31","B2",IF(B2="A1HG30","D1",IF(B2="A1HG31","D1",IF(B2="A1MG31","D2",IF(B2="A6SG30","A3",IF(B2="A6SG31","A3",IF(B2="F1CG31","C1",IF(B2="F4CG31","B3",IF(B2="F8CG30","D3"
你这个是IF嵌套,简化不了了,
在最后面加上
=IF(B2="A6HG30","E6",IF(B2="A6HG31","B2",IF(B2="A1HG30","D1",IF(B2="A1HG31","D1",IF(B2="A1MG31","D2",IF(B2="A6SG30","A3",IF(B2="A6SG31","A3",IF(B2="F1CG31","C1",IF(B2="F4CG31","B3",IF(B2="F8CG30","D3",IF(B2="S2HG31","C3",IF(B2="S2HG30","B3",IF(B2="S4HG31","B3",IF(B2="S4HG30","B3",IF(B2="S4HG40","B3",IF(B2="S8HG30","D4",IF(B2="S9HG31","B1",IF(B2="S9HG30","B1",IF(B2="S9HG40","D4",IF(B2="SF1870","B3",IF(B2="W1HG30","D4","")))))))))))))))))))))

怎么才能简化我的这个公式呢?太长了.=IF(B2=A6HG30,E6,IF(B2=A6HG31,B2,IF(B2=A1HG30,D1,IF(B2=A1HG31,D1,IF(B2=A1MG31,D2,IF(B2=A6SG30,A3,IF(B2=A6SG31,A3,IF(B2=F1CG31,C1,IF(B2=F4CG31,B3,IF(B2=F8CG30,D3 电工学一道题这个电路是怎么简化的?看到答案上的简化图把RS都简化掉了 只剩下R3456和IS E2 这题是求I 问下电路怎么简化的详细点写 一步一步来 EXCEL函数中不等于0怎么表示?我用的这个函数有很多个导致公式太长了我想简单化一下 比如我下面这个公式=IF(E90,,IF(I9>0,$I$5,IF(I90,$I$5,IF(I9 为什么V=v^0+at呢?这个公式是怎么来的?我懂了! ∑简化公式n ∑Q^n的简化公式是什么?请各位高手帮忙...急...谢谢!i=1 这个公式能否简化, 为什么一些求功的物理题用到动能定理,我怎么才能知道什么时候用这个公式呢 excel 公式简化=IF(zhu!AR20,zhu!AR2*Z3,)+IF(zhu!AS20,zhu!AS2*Z4,)+IF(zhu!AT20,zhu!AT*Z4,)+ IF(zhu!AO20,zhu!AO2*Z5,) 因为后面还要一直相加下去所以公式太长了 你公式怎么简化一下 怎样才能把作文写好?我每次考语文30分作文得10多分.这次的了18分.开头怎么写?结尾呢?经过呢?如何把作文写长?怎么才能把作文写精彩?如题“日出”这个题目又该怎么写?写一篇文章.也别太长 根号的简化根号8怎么变成2根号2?根号34怎么简化能跟我说QQ吗?根号8我是懂了,那根号25分之2呢?我的QQ是471969254 这个公式可以简化吗 这个公式对吗?百度百科上说功率(w)=2π×扭矩(Nm)×转速(rpm)/60,简化计算后成为:功率(kw)=扭矩(Nm) ×转速(rpm)/9.549.但我怎么算也出功率=60扭矩x转速/2π 如果我错了请告诉我具体的推导过程 谢谢 初中物理如何简化复杂的电路图?节点法是啥意思?怎么简化?特别是那个用节点法来简化电路,我看了3天. IF函数公式如何简化?下面的公式如何简化,=IF(OR(Y3 这个excel表格中的公式怎么列?B5=甲时,AT等于AU:AX中甲对应的标准“4”,请问我的公式哪里出错了,不能显示对应的数据呢?应该怎么列公式啊? 方差的简化公式是怎么得到的? 方差计算简化公式是怎么求出来的 .. 老是△=什么什么的 我都迷糊了?不是几何题那这个怎么念呢?拼音下 怎么用判别式确定取值范围啊。谁知道?而且还得举个例子 我才能明白 我做的是一道集合题已知集合A={x I x>0,且x包含