IF..AND Statement

  • Thread starter Thread starter HBuck
  • Start date Start date
H

HBuck

Hello,

I'm sure that this is a no-brainer for most of you, so that is why I am
posting in this forum.

I am trying to fill in cells in a worksheet using an IF..AND statement,
but it's not working properly, so I'm obviously doing something wrong.
The statement that I am using is:
=IF(AND(C4>=0, OR(C4<=25)), "XXX","") and I'm trying to find a value
within a range.

What I want to say is:

If C4 >=0
OR
C4<=25
THEN C4 = XXX
ELSE "blank"

Did I set that formula up incorrectly? Should I not use the AND
statement and have nested IFs instead? The problem that I have is it's
not doing the value check on the cell, so it doesn't place the 'XXX's
in the proper cell.

Any help would be greatly appreciated.

Holli
 
I bet you really want AND.

=if(and(c4>=0,c4<=25),"xxx","")

But this formula can't go in C4. It has to go into another cell.
 
I bet you really want AND.

=if(and(c4>=0,c4<=25),"xxx","")

But this formula can't go in C4. It has to go into another cell.
 
You are trying for an OR, not an AND. So I think Don just missed that.
It should be

=IF(OR(C4>=0,C4<=25),"XXX","")
 
You are trying for an OR, not an AND. So I think Don just missed that.
It should be

=IF(OR(C4>=0,C4<=25),"XXX","")
 
=IF(AND(C4>=0,C4<=25),"XXX","")

"IF C4 is greater than 0 AND C4 is less than or equal to 25, THEN "XXX",
ELSE "" "

If that's the logic you're looking for, then use the formula above.

Dave
 
=IF(AND(C4>=0,C4<=25),"XXX","")

"IF C4 is greater than 0 AND C4 is less than or equal to 25, THEN "XXX",
ELSE "" "

If that's the logic you're looking for, then use the formula above.

Dave
 
Not to harp, but everyone who is saying to use:
=IF(OR(C4>=0, C4<=25), "XXX","")

That will result in "XXX" being displayed if C4 contains a number, any
number. Because any number is either greater than 0 or less than 25,
or even both.
 
Not to harp, but everyone who is saying to use:
=IF(OR(C4>=0, C4<=25), "XXX","")

That will result in "XXX" being displayed if C4 contains a number, any
number. Because any number is either greater than 0 or less than 25,
or even both.
 
yup. but that is what was asked for very specifically and very clearly. so
it is no surprise that people have answered in different ways.

anyway I think Holli will have got what she wants out of this
 
Back
Top