Forum Discussion
Lala56
Jun 28, 2021Copper Contributor
Run a formula only when 1 or more cells are not blank
I have a formula
=IF(BH4<=AR4+180,{"MET"},{NOT MET"})
I want to add in not to calculate if there is no value in BH4 OR AR4.
Can you help?
=IF(BH4<=AR4+180,{"MET"},{NOT MET"})
I want to add in not to calculate if there is no value in BH4 OR AR4.
Can you help?
You have
=IF(OR(BH4="",AR=""),"",IF(BH4<=AR4+180,"MET","NOT MET"))
but it should be
=IF(OR(BH4="",AR4=""),"",IF(BH4<=AR4+180,"MET","NOT MET"))
12 Replies
- SergeiBaklanDiamond Contributor
- Lala56Copper ContributorThank you so much for your help. I am getting a #VALUE error. I plugged dates in both the fields and I still get #Value instead of met or not met and when I remove the values I still get #Value 😞
- Lala56Copper ContributorThank you very much for your help. I used your formula =IF(OR(BH4="",AR=""),"",IF(BH4<=AR4+180,"Met","Not Met")) but it gives me the #NAME? error message. I checked the equation several times for a typo but can't find one. I'm still stuck 😞
You have
=IF(OR(BH4="",AR=""),"",IF(BH4<=AR4+180,"MET","NOT MET"))
but it should be
=IF(OR(BH4="",AR4=""),"",IF(BH4<=AR4+180,"MET","NOT MET"))