Janet" wrote in message
...
Perfect!

So I am <g

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Janet" wrote in message
...
Perfect!

"Sandy Mann" wrote:

Janet,

Try making your list of numbers an array:

=IF(OR(B3={1,2,3,201,202}),C3,"")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Janet" wrote in message
...
I have got most of the statement, it is just not putting the correct
True
Value in. What I have is =IF(OR(B3=1,2,3,201,202),C3,""). If B3 has any
other
number, I want to leave the blank. What it is doing is putting in the
value
of C3. Any help would be greatly appreciated.