这三个函数公式是什么意思?(1) =IF(D7="","",ROUND(AVERAGE(D7:D10),4)) (2) =IF(F10="","",IF(F10>$G$7,"",F10)) (3) =IF(F7="","",IF(J7>0,100-ABS(J7)*100*6,100-ABS(J7)*100*3))
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/20 11:55:22
![这三个函数公式是什么意思?(1) =IF(D7=](/uploads/image/z/11689651-19-1.jpg?t=%E8%BF%99%E4%B8%89%E4%B8%AA%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%3F%281%29+%3DIF%28D7%3D%22%22%2C%22%22%2CROUND%28AVERAGE%28D7%3AD10%29%2C4%29%29+%282%29+%3DIF%28F10%3D%22%22%2C%22%22%2CIF%28F10%3E%24G%247%2C%22%22%2CF10%29%29+%283%29+%3DIF%28F7%3D%22%22%2C%22%22%2CIF%28J7%3E0%2C100-ABS%28J7%29%2A100%2A6%2C100-ABS%28J7%29%2A100%2A3%29%29)
这三个函数公式是什么意思?(1) =IF(D7="","",ROUND(AVERAGE(D7:D10),4)) (2) =IF(F10="","",IF(F10>$G$7,"",F10)) (3) =IF(F7="","",IF(J7>0,100-ABS(J7)*100*6,100-ABS(J7)*100*3))
这三个函数公式是什么意思?
(1) =IF(D7="","",ROUND(AVERAGE(D7:D10),4)) (2) =IF(F10="","",IF(F10>$G$7,"",F10)) (3) =IF(F7="","",IF(J7>0,100-ABS(J7)*100*6,100-ABS(J7)*100*3))
这三个函数公式是什么意思?(1) =IF(D7="","",ROUND(AVERAGE(D7:D10),4)) (2) =IF(F10="","",IF(F10>$G$7,"",F10)) (3) =IF(F7="","",IF(J7>0,100-ABS(J7)*100*6,100-ABS(J7)*100*3))
这是excel里面的吧?
先解释一下各函数
IF,条件函数.例子:如果A1格里面的内容是:=IF(a,b,c),表示如果a正确,则返回b(即A1里面是a的值),否则返回c.
AVERAGE(),求平均值.
ROUND(a,b),对a进行保留b位小数的四舍五入.例子:=ROUND(17.256,1),则返回17.3
ABS(),求绝对值.
(1)如果D7里面是""(表示空白),那么返回(空白),否则返回D7:D10区间的平均值,并保留4位小数.
(2)如果F10里面是"",那么返回(空白),否则返回IF(F10>$G$7,"",F10)的值,而IF(F10>$G$7,"",F10)的值是:如果F10>$G$7,那么返回(空白),否则返回F10的值.
(3)如果F7里面是"",那么返回(空白),否则返回IF(J7>0,100-ABS(J7)*100*6,100-ABS(J7)*100*3)的值,而IF(J7>0,100-ABS(J7)*100*6,100-ABS(J7)*100*3)的值是:如果J7>0,那么返回100-(J7的绝对值)*100*6,否则返回100-(J7的绝对值)*100*3.