The formula is in H4 - I want to use both formula C5-C10 =, but if C10 is
empty H4 is to =0
--
KK


"JoeU2004" wrote:

"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.

Depends on your definition of "empty". I suspect you mean: __appears__
empty. The simplest formula is:

=if(C10="", 0, C5 - C10)

Do not use IF(ISBLANK(C10),"",...). ISBLANK returns true only when the cell
is truly empty; that is, no formula and no constant.

If you use the formula above in H4, H4 might be an example of a cell that
__appears__ empty, but ISBLANK(H4) is FALSE.