FORMULA

[Kay]

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.

 

[Jacob Skaria]

=IF(COUNT(C10,C5)=2,C5-C10,0)

OR

=IF(C10,C5-C10,0)


If this post helps click Yes

 

[T. Valko]

One way...

=IF(COUNT(C5,C10)<2,0,C5-C10)

 

[Tom Hutchins]

Try this in H4:
=IF(LEN(C10)=0,0,C5-C10)

Hope this helps,

Hutch

 

[JoeU2004]

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.

 

[Kay]

I mean there is no "START
DATE" entered in the cell (it is just empty)

 

[Kay]

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

 

[Eduardo]

Hi Kay,

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

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

 

[JoeU2004]

I mean there is no "START
DATE" entered in the cell (it is just empty)

Okay. But you can still use simply IF(C10="",0,...), and I still think that
is preferrable to IF(ISBLANK(C10),0,...).


----- original message -----