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.

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.

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.

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.

2 is TRUE, 3 is TRUE, 201 is TRUE, 202 is TRUE (and similarly any non-zero
number is TRUE).
You have used those as arguments for your OR function, so of course the
answer of the OR is TRUE (regardless of whether or not B3=1), hence the IF
returns C3.
--
David Biddulph

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