Forum Discussion
Solved
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?
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"))
- Thank 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"))
- Thank you so much, it worked! For some reason the very 1st row did not calculate and left the cell with #VALUE! yet the other 60K records are correct.
