View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HBuck HBuck is offline
external usenet poster
 
Posts: 12
Default 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