I would like some feedback on the following formula for the specified range, this code seems to work on my laptop but not my desktop for an unknown reason.
68 & below = "Within Alert Level"
Inclusively between 69 and 98 = "Exceeded Alert Level"
99 & Above = "Exceeded Suspension Level"
=IF(A1>=99; "Exceeded Suspension Level"; IF(A1>=69; "Exceeded Alert Level"; IF(A1<=68; "Within Alert Level")))
Aucun commentaire:
Enregistrer un commentaire