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