IF..AND Statement

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
 
D

Dave Peterson

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.
 
D

Dave Peterson

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.
 
G

Guest

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","")
 
G

Guest

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","")
 
G

Guest

=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
 
G

Guest

=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
 
J

John Fuller

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.
 
J

John Fuller

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.
 
G

Guest

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
 

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

Similar Threads

somewhat complex if statement help PLEASE!!!! 1
Learning arrays. 13
Calculation using IF 6
Calculation using IF 1
Hiding formula if cel reference is blank 2
INDIRECT AND IF STATEMENT 8
adding in multiple numbers when on cell is Blank 5
Combining VLOOKUPS? 2

Top