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/12/19 19:46:01
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(给定条件,返回满足条件时的值(真),返回不满足条件时的值(假)).