嵌套IF和ISBLANK [英] Nesting IF and ISBLANK
本文介绍了嵌套IF和ISBLANK的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
请帮助.我正在尝试让单元格返回空白,但遇到了麻烦.
Please help. I'm trying to get the cell to return blank but I'm having trouble.
=IF(AND($I2>1,AG2>=0.5),1,IF(AND($I2<1,AG2<0.5),1,IF(AG2=""),"",0))
当我包含最后一个参数IF(AG2 ="),",0时出现错误消息.
There's and error message when I include the last argument IF(AG2=""),"",0.
此替代方法无效 = IF(ISBLANK(AG2),",IF(AND($ I2> 1,AG2> = 0.5),1,IF(AND($ I2< 1,AG2 <0.5),1,0)))
我也尝试使用IFERROR返回空白而不是DIV/O,这会破坏我的数据透视表.非常感谢
I've also tried with using IFERROR to return blank rather than DIV/O which ruins my pivot table. Thanks so much
推荐答案
也许:
=IF(AND($I2>1,AG2>=0.5),1,IF(AND($I2<1,AG2<0.5),1,IF(AG2="","",0)))
您的错误带有括号.
这篇关于嵌套IF和ISBLANK的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文