LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Issam LAdki
 
Posts: n/a
Default Blank Cells,

Thanks for your previous invaluable help, and it seems I need it again.

I have the following formula in a spreadsheet in Cell E7

=IF((ISBLANK(D7)),"
",(IF((OR(ISTEXT(C7),(ISBLANK(C7)))),D7+TIME(7,0,0 ),(IF(D7<MOD(C7+TIME(12,0,
0),1),"ERR",D7+TIME(7,0,0))))))

It does work as expected except for the first part
((ISBLANK(D7))," ",
Basically, what I am trying to do here is that if D7 is blank, then E7 will
also be blank, else continue with
the formula as shown (which incidentally works fine for the rest).

Thanks in advance for your help in this.

Issam


 
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
Copy down - special to fill only the blank cells Mike Excel Discussion (Misc queries) 3 April 18th 05 10:08 PM
blank cells R.VENKATARAMAN Excel Discussion (Misc queries) 1 April 6th 05 10:25 AM
Blank Cells in Pivot Tables Greg Excel Discussion (Misc queries) 1 March 16th 05 09:23 PM
Non Blank - Blank Cells???? Reggie Excel Discussion (Misc queries) 3 January 12th 05 12:04 AM
In Exel 2000, stop the blank cells (with formulas) from printing. tonyoc Excel Discussion (Misc queries) 1 December 10th 04 12:38 AM


All times are GMT +1. The time now is 05:26 PM.

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"