IF OR formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bluezcruizer - 23 Feb 2007 20:14 GMT

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

Reply to this Message

Pete_UK - 23 Feb 2007 20:24 GMT

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

On Feb 23, 8:14 pm, bluezcruizer
<bluezcrui...@discussions.microsoft.com> wrote:

> Hi all.
>
[quoted text clipped - 19 lines]
>
> bluezcruizer

Reply to this Message

bluezcruizer - 23 Feb 2007 20:36 GMT

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

bc

> You need to amend your formula slightly:
>
[quoted text clipped - 31 lines]
> >
> > bluezcruizer

Reply to this Message

Pete_UK - 23 Feb 2007 20:47 GMT

You're welcome - thanks for feeding back.

Pete

On Feb 23, 8:36 pm, bluezcruizer
<bluezcrui...@discussions.microsoft.com> wrote:

> Thank you Pete -- that did it. A slight misunderstanding on my part of the
> formula.
[quoted text clipped - 38 lines]
>
> - Show quoted text -

Reply to this Message

Don Guillett - 23 Feb 2007 23:36 GMT

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

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Hi all.
>
[quoted text clipped - 23 lines]
>
> bluezcruizer

Reply to this Message