Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy down - special to fill only the blank cells | Excel Discussion (Misc queries) | |||
blank cells | Excel Discussion (Misc queries) | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Non Blank - Blank Cells???? | Excel Discussion (Misc queries) | |||
In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) |