Forum Discussion

Lala56's avatar
Lala56
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's avatar
    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's avatar
SergeiBaklan
Diamond Contributor
Jun 28, 2021

Lala56 

Perhaps

=IF (BH4<>"")+(AR4<>""), "",
 IF(BH4<=AR4+180,"MET",NOT MET")
)
  • Lala56's avatar
    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 😞

Resources