Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need help with conditions Liz
I've a question...........
If A1 = 2/17/2007 B1 = 2/22/2007 I've cell C1 with a formula to calculate the difference between those dates and based on the result which appears on C1 I've a condition in cell D1 which is if C1 is greater or equal to 0 then YES and if less than 0 then NO. But I need one more condition that is if c1 is has no value which is when the A1 and B1 is blank I need the D1 cell to appear blank to but should have the condition in place. PS: I've formatted the C column by unchecking the zero values under Tools/Options/View. Thanks Liz |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
Conditions | Excel Discussion (Misc queries) | |||
if then else conditions | Excel Discussion (Misc queries) | |||
Two Conditions | Excel Discussion (Misc queries) | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |