Array formula

[alee001]

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")))

[daddylonglegs]

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

[alee001]

It work!....Thanks you for your help.