FORMULA
Try this in H4:
=IF(LEN(C10)=0,0,C5-C10)
Hope this helps,
Hutch
"Kay" wrote:
I have the following formula in Cell H4
= cell C5 (which is the end date) minus cell C10 (which is the start date) I
want to add another formula in Cell H4 to make it = 0 if Cell C10 is empty.
Thank you.
--
KK
|