Hello everyone, I am the new kid on the block. Need help with the above function.
Cell A1 = TX
Cell A2 = =If(OR(A1,= NM,AL,FL),"Yes","No")
I would expect "No" to be in Cell A1
I get error message #NAME?
What's wrong with the formula
Hello everyone, I am the new kid on the block. Need help with the above function.
Cell A1 = TX
Cell A2 = =If(OR(A1,= NM,AL,FL),"Yes","No")
I would expect "No" to be in Cell A1
I get error message #NAME?
What's wrong with the formula
Last edited by jerval451234; 01-09-2013 at 11:50 PM.
Here is my cheat sheet on using IF(OR... with multiple options.
abousettaHTML Code:
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Just for clarification, the curly brackets are not put in by the user, but by Excel for array formulas. Array formulas are entered using Ctrl + Shift + Enter not just Enter. If you do this correctly then the curly brackets will be added by Excel.
Hope this helps.
abousetta
Last edited by abousetta; 01-10-2013 at 09:20 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks