I am trying to evaluate data in 2 fields and post a text response to the evaluation of the 2 fields. here is what my formula looks like:
=IF(AND(OR(C82=55,56,57,58,59,60,61,62,63,64), C83>100000), "TRUST RANGE", "NOT TRUST RANGE")
Now I am not getting an error message but the formula is not evaluating the data in C82 correctly with C83.
If I enter 61 in C82 and 100500 in C83 I am getting the correct response of "TRUST RANGE" But if I change the 61 to 66 the response does not change to "NOT IN TRUST RANGE" as it should.
I have tried googling for any information if I can use both an AND & OR in a IF but I can not find anything on it.
Anyone out there have any suggestions on how I can do this?
Bookmarks