I want to find the "Item?" on cell A2 input (Ctrl+Shift+Enter) a formula as following when cell A1 as numberic, but result is "N/A". Anyone help.....
=IF(A1=OR({1,2,3,6,9}),"Item A",IF(A1=OR({4,5,7}),"Item B",IF(A1=OR({8,10}),"Item C","N/A")))