FORMULA
Hi Kay,
=if(C10="",0,C5-C10)
"Kay" wrote:
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.
|