Excel2007中的公式=IF(H57="","",(MAX(H57:H64)-MIN(H57:H64))/(MAX(H57:H64)+MIN(H57:H64)))请高手们帮忙分析一下上面的公式.(MAX(H57:H64)-MIN(H57:H64))/(MAX(H57:H64)+MIN(H57:H64))这是个什么值,名称是什么?
来源:学生作业帮助网 编辑:作业帮 时间:2024/09/02 00:26:12
![Excel2007中的公式=IF(H57=](/uploads/image/z/5530174-70-4.jpg?t=Excel2007%E4%B8%AD%E7%9A%84%E5%85%AC%E5%BC%8F%3DIF%28H57%3D%22%22%2C%22%22%2C%28MAX%28H57%3AH64%29-MIN%28H57%3AH64%29%29%2F%28MAX%28H57%3AH64%29%2BMIN%28H57%3AH64%29%29%29%E8%AF%B7%E9%AB%98%E6%89%8B%E4%BB%AC%E5%B8%AE%E5%BF%99%E5%88%86%E6%9E%90%E4%B8%80%E4%B8%8B%E4%B8%8A%E9%9D%A2%E7%9A%84%E5%85%AC%E5%BC%8F.%28MAX%28H57%3AH64%29-MIN%28H57%3AH64%29%29%2F%28MAX%28H57%3AH64%29%2BMIN%28H57%3AH64%29%29%E8%BF%99%E6%98%AF%E4%B8%AA%E4%BB%80%E4%B9%88%E5%80%BC%2C%E5%90%8D%E7%A7%B0%E6%98%AF%E4%BB%80%E4%B9%88%3F)
Excel2007中的公式=IF(H57="","",(MAX(H57:H64)-MIN(H57:H64))/(MAX(H57:H64)+MIN(H57:H64)))请高手们帮忙分析一下上面的公式.(MAX(H57:H64)-MIN(H57:H64))/(MAX(H57:H64)+MIN(H57:H64))这是个什么值,名称是什么?
Excel2007中的公式
=IF(H57="","",(MAX(H57:H64)-MIN(H57:H64))/(MAX(H57:H64)+MIN(H57:H64)))
请高手们帮忙分析一下上面的公式.
(MAX(H57:H64)-MIN(H57:H64))/(MAX(H57:H64)+MIN(H57:H64))这是个什么值,名称是什么?
Excel2007中的公式=IF(H57="","",(MAX(H57:H64)-MIN(H57:H64))/(MAX(H57:H64)+MIN(H57:H64)))请高手们帮忙分析一下上面的公式.(MAX(H57:H64)-MIN(H57:H64))/(MAX(H57:H64)+MIN(H57:H64))这是个什么值,名称是什么?
MAX(H57:H64)——从H57:H64中选择最大值,
MIN(H57:H64)——从H57:H64中选择最小值.
组合起来:(MAX(H57:H64)-MIN(H57:H64))/(MAX(H57:H64)+MIN(H57:H64))就是一个除法公式.
=IF(H57="","",上式)意思是如果H57值为空的话就返回空值,如果不为空就返回上式计算结果.
if是条件判别公式,及if(给定条件,返回满足条件时的值(真),返回不满足条件时的值(假)).