You are right.
Alok

"Sandy Mann" wrote:

"Alok" wrote in message
...
Another way is

=IF(OR(C1={6,11,12,84,86,87,88,89}),"a","b")

the above has to be array entered.(Ctrl-Shift-Enter)



It works for me without being array entered.

--
Sandy

Replace@mailinator with @tiscali.co.uk

","a")