If/Or statement
 

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.

If/Or statement
 

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.

If/Or statement
 

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.

If/Or statement
 

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.

If/Or statement
 

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.