早教吧作业答案频道 -->其他-->
IF函数得出来的数据不能累加怎么办=IF(C3>=109.5%,14.8,IF(C3>=108.5%,14.39,IF(C3>=107.5%,13.98,IF(C3>=106.5%,13.57,IF(C3>=105.5%,13.16,IF(C3>=104.5%,12.75,IF(C3>=103.5%,12.34,)))))))&IF(C3>=103.5%,"",IF(C3>=102.5%,11.92,IF(C3>=101.5%,11.5
题目详情
IF函数得出来的数据不能累加怎么办
=IF(C3>=109.5%,14.8,IF(C3>=108.5%,14.39,IF(C3>=107.5%,13.98,IF(C3>=106.5%,13.57,IF(C3>=105.5%,13.16,IF(C3>=104.5%,12.75,IF(C3>=103.5%,12.34,)))))))&IF(C3>=103.5%,"",IF(C3>=102.5%,11.92,IF(C3>=101.5%,11.51,IF(C3>=100.5%,11.1,IF(C3>=99.5%,7.4,IF(C3>=98.5%,6.66,IF(C3>=97.5%,5.92,IF(C3>=96.5%,5.18,))))))))&IF(C3>=96.5%,"",IF(C3>=95.5%,4.44,IF(C3>=95%,3.7,0)))
函数正确,但用“--”,加0、*1或/1都会错误,
=IF(C3>=109.5%,14.8,IF(C3>=108.5%,14.39,IF(C3>=107.5%,13.98,IF(C3>=106.5%,13.57,IF(C3>=105.5%,13.16,IF(C3>=104.5%,12.75,IF(C3>=103.5%,12.34,)))))))&IF(C3>=103.5%,"",IF(C3>=102.5%,11.92,IF(C3>=101.5%,11.51,IF(C3>=100.5%,11.1,IF(C3>=99.5%,7.4,IF(C3>=98.5%,6.66,IF(C3>=97.5%,5.92,IF(C3>=96.5%,5.18,))))))))&IF(C3>=96.5%,"",IF(C3>=95.5%,4.44,IF(C3>=95%,3.7,0)))
函数正确,但用“--”,加0、*1或/1都会错误,
▼优质解答
答案和解析
数值运算,把&改为+,把""改为0就行了.
=IF(C3>=109.5%,14.8,IF(C3>=108.5%,14.39,IF(C3>=107.5%,13.98,IF(C3>=106.5%,13.57,IF(C3>=105.5%,13.16,IF(C3>=104.5%,12.75,IF(C3>=103.5%,12.34,0)))))))+IF(C3>=103.5%,0,IF(C3>=102.5%,11.92,IF(C3>=101.5%,11.51,IF(C3>=100.5%,11.1,IF(C3>=99.5%,7.4,IF(C3>=98.5%,6.66,IF(C3>=97.5%,5.92,IF(C3>=96.5%,5.18,0))))))))+IF(C3>=96.5%,0,IF(C3>=95.5%,4.44,IF(C3>=95%,3.7,0)))
太长的IF公式,可用：
=LOOKUP(C3,{0,95,95.5,96.5,97.5,98.5,99.5,100.5,101.5,102.5,103.5,104.5,105.5,106.5,107.5,108.5,109.5}%,{0,3.7,4.44,5.18,5.92,6.66,7.4,11.1,11.51,11.92,12.34,12.75,13.16,13.57,13.98,14.39,14.8})
两个{ }间的数据一一对应就行了.
=IF(C3>=109.5%,14.8,IF(C3>=108.5%,14.39,IF(C3>=107.5%,13.98,IF(C3>=106.5%,13.57,IF(C3>=105.5%,13.16,IF(C3>=104.5%,12.75,IF(C3>=103.5%,12.34,0)))))))+IF(C3>=103.5%,0,IF(C3>=102.5%,11.92,IF(C3>=101.5%,11.51,IF(C3>=100.5%,11.1,IF(C3>=99.5%,7.4,IF(C3>=98.5%,6.66,IF(C3>=97.5%,5.92,IF(C3>=96.5%,5.18,0))))))))+IF(C3>=96.5%,0,IF(C3>=95.5%,4.44,IF(C3>=95%,3.7,0)))
太长的IF公式,可用：
=LOOKUP(C3,{0,95,95.5,96.5,97.5,98.5,99.5,100.5,101.5,102.5,103.5,104.5,105.5,106.5,107.5,108.5,109.5}%,{0,3.7,4.44,5.18,5.92,6.66,7.4,11.1,11.51,11.92,12.34,12.75,13.16,13.57,13.98,14.39,14.8})
两个{ }间的数据一一对应就行了.
看了IF函数得出来的数据不能累加怎...的网友还看了以下：
行政职业能力测验如果(5,7)=74,(4,6)=52,(3,5)=34,则(0,4)=()A.5 2020-04-07 …
被损坏的计算器(555－5)÷5÷5－5(5＋5＋5＋5＋5＋5＋5＋5＋5＋5＋5＋5＋5＋5＋ 2020-04-07 …
、按一定规律排列的一串数：1/1,-1/3,2/3,-3/3,1/5,-2/5,3/5,-4/5, 2020-05-14 …
123312313213232111131+1+1+5+5+8+8+6+2+2+2+2+2+2+2 2020-05-17 …
三角形abo的顶点坐标分别是a（负5,5）b（5,5）c（0,0）三角形abo的顶点坐标分别是a（ 2020-06-03 …
一.计算下面各题（把过程写清楚）12分之5×5分之445分之24÷27分之1214÷10分之76分 2020-06-06 …
根据乘方的定义：5的2次方=5*5,5的3次方=5*5*5则5的2次方*5的3次方=（5*5）*（ 2020-07-01 …
lingo求解谢谢了急用悬赏20请帮忙修改一下并得出准确答案谢谢了model:max=w1+w2+w 2020-10-31 …
（1）2/3÷5+5÷2/3（2）5×5/6+5/6×5（3）3/8×68-1/8÷1/68（4）（ 2020-11-06 …
5,5,5,1怎样算24除了3个5,1个1,用加减乘除,算24点,怎么算?5*(5-1/5)三个5, 2021-01-05 …