Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protect IF statement AND allow data entry | Excel Worksheet Functions | |||
SQL concatenation statement | Excel Discussion (Misc queries) | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions |