mercredi 8 novembre 2017

Formulate response in excel referencing value in Cell

need a little help with IF & OR to formulate response base on value in Cell M8, I believe i'm very close to what I want but I don't understand the error it.

Ultimately I want the formula to perform the following function

  • If Cell M8 = No Access, it will display No Access
  • But if M8 have a value above 61, it'll display "Exceeded Pre-Determined Level", and if value is between 43 to 61,it'll display "Exceeded Alert Level"

=IF(M8="No Access","No Access", (ABS(M8)>=61,"Exceeded Pre-Determined Level" OR(ABS(M8)>=43,"Exceeded Alert Level")))

Aucun commentaire:

Enregistrer un commentaire