Hi
This works OK for me! You seem to have a lot of extra brackets in the
formula, but I'm guessing that is to help you track which bit does which
function.

--
Andy.


"Issam LAdki" wrote in message
...
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