哪位知道这些函数公式是什么意思?P5-$D$20、ROUND(D5/J$22,2)、IF(E5>D$26,"×",IF(E5$D$27,$D$25-ABS(G5-$D$27)*$D$28,$D$25-ABS(G5-$D$27)*D$29))>0,IF(G5=$D$27,$D$25,IF(G5>$D$27,$D$25-ABS(G5-$D$27)*$D$28,$D$25-ABS(G5-$D$27)*D$29)),0),3)急
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/20 10:50:18
![哪位知道这些函数公式是什么意思?P5-$D$20、ROUND(D5/J$22,2)、IF(E5>D$26,](/uploads/image/z/13963428-36-8.jpg?t=%E5%93%AA%E4%BD%8D%E7%9F%A5%E9%81%93%E8%BF%99%E4%BA%9B%E5%87%BD%E6%95%B0%E5%85%AC%E5%BC%8F%E6%98%AF%E4%BB%80%E4%B9%88%E6%84%8F%E6%80%9D%3FP5-%24D%2420%E3%80%81ROUND%28D5%2FJ%2422%2C2%29%E3%80%81IF%28E5%3ED%2426%2C%22%C3%97%22%2CIF%28E5%24D%2427%2C%24D%2425-ABS%28G5-%24D%2427%29%2A%24D%2428%2C%24D%2425-ABS%28G5-%24D%2427%29%2AD%2429%29%29%3E0%2CIF%28G5%3D%24D%2427%2C%24D%2425%2CIF%28G5%3E%24D%2427%2C%24D%2425-ABS%28G5-%24D%2427%29%2A%24D%2428%2C%24D%2425-ABS%28G5-%24D%2427%29%2AD%2429%29%29%2C0%29%2C3%29%E6%80%A5)
哪位知道这些函数公式是什么意思?P5-$D$20、ROUND(D5/J$22,2)、IF(E5>D$26,"×",IF(E5$D$27,$D$25-ABS(G5-$D$27)*$D$28,$D$25-ABS(G5-$D$27)*D$29))>0,IF(G5=$D$27,$D$25,IF(G5>$D$27,$D$25-ABS(G5-$D$27)*$D$28,$D$25-ABS(G5-$D$27)*D$29)),0),3)急
哪位知道这些函数公式是什么意思?P5-$D$20、ROUND(D5/J$22,2)、
IF(E5>D$26,"×",IF(E5$D$27,$D$25-ABS(G5-$D$27)*$D$28,$D$25-ABS(G5-$D$27)*D$29))>0,IF(G5=$D$27,$D$25,IF(G5>$D$27,$D$25-ABS(G5-$D$27)*$D$28,$D$25-ABS(G5-$D$27)*D$29)),0),3)急求!
哪位知道这些函数公式是什么意思?P5-$D$20、ROUND(D5/J$22,2)、IF(E5>D$26,"×",IF(E5$D$27,$D$25-ABS(G5-$D$27)*$D$28,$D$25-ABS(G5-$D$27)*D$29))>0,IF(G5=$D$27,$D$25,IF(G5>$D$27,$D$25-ABS(G5-$D$27)*$D$28,$D$25-ABS(G5-$D$27)*D$29)),0),3)急
1、
IF(E5>D$26,"×",IF(E5<$L$26,"总分:0","√"))
意思是
将E5单元格中的数值于D26单元格中的数值作比较,如果前者大,则显示“×”,
如果小于或者等于,再将E5与L26相比较,
如果E5比L26小,则显示“总分:0”,否则显示“√”
2、
ROUND((D5-D$24)/D$24*100,5)
意思
用D5与D24做差,得到的差与D24做商后再乘以100(其实就是D5 与D24的差所占D24的百分比,在四舍五入保留5位小数)
3、
ROUND(IF(IF(G5=$D$27,$D$25,IF(G5>$D$27,$D$25-ABS(G5-$D$27)*$D$28,$D$25-ABS(G5-$D$27)*D$29))>0,IF(G5=$D$27,$D$25,IF(G5>$D$27,$D$25-ABS(G5-$D$27)*$D$28,$D$25-ABS(G5-$D$27)*D$29)),0),3)
\ \代表绝对值,就是那个ABS
而$这个美元符号代表所定地址而已,不妨碍,只是在拖拉公式的时候被锁定的单元格不变(或者行不变或者列不变)