IF OR formula

[bluezcruizer]

Hi all.

I've got a problem. Here's the scenario:

I've got one cell that has a value (block is A6), and then a string of cells
with a value in each (A3, B3, C3, D3, E3). I want H6 to test A6 against A3 -
E3. As there will be more rows of data (A7..A70), I'll be copying the
formula in H7 to H70 to test against A7 to A70 against A3 - E3.

The test is if A6 is equal to one of the values, then "x", otherwise ""
(blank). This is the formula I've put together:

=IF(OR(A6=$A$3,$B$3,$C$3,$D$3,$E$3),"x","")

The problem I am having is regardless of what's in A6, I'm returning "x";
matching or otherwise. Example: A3 = 9, B3 = 10.2, C3 = 1500, D3 = 26, E3 =
-2.34. In cell A6, the value listed is 32. According to the formula, H7
should return as blank. However, I'm getting an "x".

Can someone help me out by determining what went wrong and why the formula's
not working as it should? Thank you!

bluezcruizer

 

[Pete_UK]

You need to amend your formula slightly:

=IF(OR(A6=A$3,A6=B$3,A6=C$3,A6=D$3,A6=E$3),"x","")

Then copy it down into H7:H70.

Hope this helps.

Pete

 

[bluezcruizer]

Thank you Pete -- that did it. A slight misunderstanding on my part of the
formula.

bc

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

Thank you Pete -- that did it. A slight misunderstanding on my part of the
formula.

bc






- Show quoted text -

 

[Don Guillett]

try
=IF(COUNTIF($A$3:$E$3,A6)>0,"x","")