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

try
=IF(AND(C4=0, C4<=25), "XXX","")
--
Don Guillett
SalesAid Software

"HBuck" wrote in message
ups.com...
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

Thank you Don!

Your solution is actually more accurate than my own.

HBuck



Don Guillett wrote:
try
=IF(AND(C4=0, C4<=25), "XXX","")
--
Don Guillett
SalesAid Software

"HBuck" wrote in message
ups.com...
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

glad to help

--
Don Guillett
SalesAid Software

"HBuck" wrote in message
oups.com...
Thank you Don!

Your solution is actually more accurate than my own.

HBuck



Don Guillett wrote:
try
=IF(AND(C4=0, C4<=25), "XXX","")
--
Don Guillett
SalesAid Software

"HBuck" wrote in message
ups.com...
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

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

--
Allllen


"Don Guillett" wrote:

try
=IF(AND(C4=0, C4<=25), "XXX","")
--
Don Guillett
SalesAid Software

"HBuck" wrote in message
ups.com...
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.



HBuck wrote:

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

--

Dave Peterson

Just after submitting this problem to the group, I actually solved it.

HBuck


HBuck wrote:
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

=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
--
Brevity is the soul of wit.


"HBuck" wrote:

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

=IF(OR(C4=0, C4<=25), "XXX","")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"HBuck" wrote in message
ups.com...
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

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.


Bernard Liengme wrote:
=IF(OR(C4=0, C4<=25), "XXX","")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"HBuck" wrote in message
ups.com...
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

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

--
Allllen


"John Fuller" wrote:

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.


Bernard Liengme wrote:
=IF(OR(C4=0, C4<=25), "XXX","")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"HBuck" wrote in message
ups.com...
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