LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
shade cells based on conditions - i have more than 3 conditions Mo2 Excel Worksheet Functions 3 March 30th 07 07:19 AM
Conditions Fanntheman Excel Discussion (Misc queries) 2 September 20th 06 03:15 AM
if then else conditions wrosie Excel Discussion (Misc queries) 4 December 18th 05 02:50 PM
Two Conditions Xandlyn Excel Discussion (Misc queries) 5 September 23rd 05 08:24 PM
How to multiple conditions to validate more than 2 conditions to . Bhuvana Govind Excel Worksheet Functions 1 January 28th 05 07:07 PM


All times are GMT +1. The time now is 08:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"