早教吧作业答案频道 -->其他-->
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函数得出来的数据不能累加怎...的网友还看了以下:
某贴息债券面值为100元,3月1日的贴现价格为98.5元,5月1日到期,采取单利计算,如何计算?某贴 2020-03-30 …
线性规划LINGO-10*x-2*y >= -10;-10*x-2*y=-25;-36*x-11* 2020-05-13 …
70,68,84,85,55,76,95,80,92,98的中位数是谁! 2020-05-24 …
参与两个数学活动,再回答问题:活动①:观察下列两个两位数的积(两个乘数的十位上的数都是9,个位上的 2020-06-11 …
50*92%=98%*X一块地选用发芽侓92%的麦种要50千克,如选用发芽为98%的麦种播种要多少 2020-06-18 …
100+99+98-97-96+95+94-93-92+...+7+6-5-4+3+2-1=?快! 2020-07-16 …
2+3=52+3+4=92+3+4+5=142+3+4+5+6=202+3+4+5+6+7=272 2020-07-18 …
能简算的一定要简算15.25-3.17+0.75-6.8314.5×0.990.25×12.5×3 2020-07-19 …
甲、乙两同学本学期每个单元的从测验成绩如下甲:100,98,100,90,96,91,89,99,1 2020-11-29 …
81宫格,1-9填入各排各列不能重复7*8*4***92*9**1****5**32*****2** 2020-12-26 …