Multiple Stacked IF formula with OR function
I have got a column called [Status Code] which has a single letter between A-J in it.
I then have an adjacent cell where I want to return a specific name depending on which letter is in the previous cell. However I have tried various combinations and cant seem to get it to work. It is nearly there but still erroring. I have checked that the IF and OR functions work on their own but cant seem to bring them all into one line.
=IF([Status Code]1 = "A", "Greg", IF(OR([Status Code]1 ="B",[Status Code]= "E"), "Carys", IF(OR([Status Code]1 = "C",[Status Code]1 = "D",[Status Code]1 = "F",[Status Code]1 = "H"), "Olivia", IF([Status Code]1 = "G", "Barry", "Warren"))))
can someone spot what is wrong with my formula and help get this working would be much appreciated.
Comments
-
Hi Warren,
You're just missing a 1 in your second IF statement:
=IF([Status Code]1 = "A", "Greg", IF(OR([Status Code]1 ="B",[Status Code]1= "E"), "Carys", IF(OR([Status Code]1 = "C",[Status Code]1 = "D",[Status Code]1 = "F",[Status Code]1 = "H"), "Olivia", IF([Status Code]1 = "G", "Barry", "Warren"))))
-
Awesome thanks Chris.
Sorry was late at night UK time, and failed to spot this simple error!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!