IF..AND Statement
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
|