Forum Discussion

Copper Contributor

Jun 28, 2021

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?

excel

Formulas and Functions

office 365

HansVogelaar
Jun 29, 2021
Lala56

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"))

SergeiBaklan

Diamond Contributor

Jun 28, 2021

Lala56

Perhaps

=IF (BH4<>"")+(AR4<>""), "",
 IF(BH4<=AR4+180,"MET",NOT MET")
)

Lala56

Copper Contributor

Jun 29, 2021

Thank 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 😞