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

12 Replies

    • Lala56's avatar
      Lala56
      Copper Contributor
      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 😞
    • Lala56's avatar
      Lala56
      Copper Contributor
      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 😞
      • 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"))

Resources