函数=IF(COUNTIF(请款方式!$A$3:$B$503,C2)>0,"Y",IF(COUNTIF(请款方式!$C$3:$D$503,C=IF(COUNTIF(请款方式!$A$3:$B$503,#REF!)>0,"Y",IF(COUNTIF(请款方式!$C$3:$D$503,#REF!)>0,"C",IF(COUNTIF(请款方式!$E$3:$F$503,#REF!)>0,"X",
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/04 02:57:31
![函数=IF(COUNTIF(请款方式!$A$3:$B$503,C2)>0,](/uploads/image/z/3890966-14-6.jpg?t=%E5%87%BD%E6%95%B0%3DIF%28COUNTIF%28%E8%AF%B7%E6%AC%BE%E6%96%B9%E5%BC%8F%21%24A%243%3A%24B%24503%2CC2%29%3E0%2C%22Y%22%2CIF%28COUNTIF%28%E8%AF%B7%E6%AC%BE%E6%96%B9%E5%BC%8F%21%24C%243%3A%24D%24503%2CC%3DIF%28COUNTIF%28%E8%AF%B7%E6%AC%BE%E6%96%B9%E5%BC%8F%21%24A%243%3A%24B%24503%2C%23REF%21%29%3E0%2C%22Y%22%2CIF%28COUNTIF%28%E8%AF%B7%E6%AC%BE%E6%96%B9%E5%BC%8F%21%24C%243%3A%24D%24503%2C%23REF%21%29%3E0%2C%22C%22%2CIF%28COUNTIF%28%E8%AF%B7%E6%AC%BE%E6%96%B9%E5%BC%8F%21%24E%243%3A%24F%24503%2C%23REF%21%29%3E0%2C%22X%22%2C)
函数=IF(COUNTIF(请款方式!$A$3:$B$503,C2)>0,"Y",IF(COUNTIF(请款方式!$C$3:$D$503,C=IF(COUNTIF(请款方式!$A$3:$B$503,#REF!)>0,"Y",IF(COUNTIF(请款方式!$C$3:$D$503,#REF!)>0,"C",IF(COUNTIF(请款方式!$E$3:$F$503,#REF!)>0,"X",
函数=IF(COUNTIF(请款方式!$A$3:$B$503,C2)>0,"Y",IF(COUNTIF(请款方式!$C$3:$D$503,C
=IF(COUNTIF(请款方式!$A$3:$B$503,#REF!)>0,"Y",IF(COUNTIF(请款方式!$C$3:$D$503,#REF!)>0,"C",IF(COUNTIF(请款方式!$E$3:$F$503,#REF!)>0,"X",
函数=IF(COUNTIF(请款方式!$A$3:$B$503,C2)>0,"Y",IF(COUNTIF(请款方式!$C$3:$D$503,C=IF(COUNTIF(请款方式!$A$3:$B$503,#REF!)>0,"Y",IF(COUNTIF(请款方式!$C$3:$D$503,#REF!)>0,"C",IF(COUNTIF(请款方式!$E$3:$F$503,#REF!)>0,"X",
#REF!——公式被你移动到超出引用地址.如原来是引用A1,公式往左或上粘贴,就超出引用地址而显示错误值.
=IF(COUNTIF(请款方式!$A$3:$B$503,A1)>0,"Y",IF(COUNTIF(请款方式!$C$3:$D$503,C1)>0,"C",IF(COUNTIF(请款方式!$E$3:$F$503,E1)>0,"X","")))【假设】
从里往外解释:
COUNTIF——条件计数函数
COUNTIF(请款方式!$A$3:$B$503,A1)——统计《请款方式》工作表当中的$A$3:$B$503区域里面,有A1的单元格个数
COUNTIF(请款方式!$A$3:$B$503,A1)>0——即有一个即以上A1的
IF——条件判断函数
IF(COUNTIF(请款方式!$A$3:$B$503,A1)>0,"Y"——如果《请款方式》工作表当中的$A$3:$B$503区域里面,有跟A1相同的,就返回“Y”,否则,就返回下一个给定字符串(本公式为执行下一个判断)
(下同)……如果以上三个条件都不符合,就返回空值“”.