excel IF 函数
=IF(F52<0.45,"-20",IF(0.45<=F52<0.55,-10,IF(0.55<=F52<0.65,0,IF(0.65<=F52<0.75,10,IF(0.75<=F52<0.85,20,IF(0.85<=F52<1,30,IF(F52=1,50,0))))))) 哪里错啦 这个结果在0.45和1 都是对的 中间就全部不对了 麻烦指点下
=IF(F52<0.45,"-20",IF(F52<0.55,-10,IF(F52<0.65,0,IF(F52<0.75,10,IF(F52<0.85,20,IF(F52<1,30,IF(F52=1,50,0))))))) 好了
=if(f52=0.45,f52=0.55,f52=0.65,f52=0.75,f52=0.85,f52<1)=true,30,if(f52=1,50,0))))))) 试试
答:余割 cscA=斜边/对边=1/sinA, 正割 secA=斜边/邻边=1/cosA.详情>>