I think I am trying to creat an IF statement with 2 TRUE arguments but if anybody that could help, it would be greatly appreciated!
I would like the formaula to read:
If Cell A equals "1", return "Z" but if Cell A equals "2", return "Y", Finally if Cell A neither matches "1" or "2" return "False"
Rather than your usual IF statement, I would like to extend it - does that make sense?
Thanks in advance.
Bookmarks