|You can eliminate the AND, but you can not eliminate the Nested IF.|
A basic IF statement checks for the occurrence of one value and returns one value if that value exists, and another value if it doesn't. Once you add a second condition, you are actually looking for 1 of 3 values to be returned - one if the first value exists, another if the second value exists, and a third if neither value exists - therefore you must use a nested IF.
This untested formula eliminates the AND. In this case you must test for the highest value first and work your way down since the IF will stop checking as soon it is TRUE.
BTW...If you don't want to use a Nested IF, you can use VLOOKUP, but that is not as simple.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03