Jun 28 2021 02:20 PM
Jun 28 2021 02:30 PM
Jun 28 2021 02:39 PM
Jun 29 2021 09:18 AM
Jun 29 2021 09:32 AM
Jun 29 2021 11:31 AM
SolutionYou 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"))
Jun 29 2021 01:34 PM
Jun 29 2021 01:38 PM
Could one of the cells contain a text value instead of a number?
Jun 29 2021 05:40 PM
Jun 30 2021 12:20 AM
I'm sorry, I don't understand.
If you wish, you can attach a small sample workbook that demonstrates the problem.
Jul 01 2021 08:21 AM
Jul 01 2021 08:38 AM
=IF(BR4="Met","N/A",IF(OR(BH4="",AR4=""),"",IF(BH4<=AR4+180,"MET","NOT MET")))
Jul 06 2021 11:44 AM
Jun 29 2021 11:31 AM
SolutionYou 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"))