You don't have the syntax quite right, try this version
=IF(OR(A1={1,2,3,6,9}),"Item A",IF(OR(A1={4,5,7}),"Item B",IF(OR(A1={8,10}),"Item C","N/A")))
it doesn't need CTRL+SHIFT+ENTER
You don't have the syntax quite right, try this version
=IF(OR(A1={1,2,3,6,9}),"Item A",IF(OR(A1={4,5,7}),"Item B",IF(OR(A1={8,10}),"Item C","N/A")))
it doesn't need CTRL+SHIFT+ENTER
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks