-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
In cell W19;
Where X is the true condition and A is the false condition that you want to pull.
Or if you actually want the cell to specifically state X or A;
Code:
=IF(AND(G19>=19,G19<=99),X,A)Where X is the true condition and A is the false condition that you want to pull.
Or if you actually want the cell to specifically state X or A;
Code:
=IF(AND(G19>=19,G19<=99),"X","A")
Last edited:
Upvote
0
Similar threads
- Question
