IF OR formula

B

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
 
P

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
 
B

bluezcruizer

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

bc
 
P

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 -
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top