Thread: FORMULA
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tom Hutchins Tom Hutchins is offline
external usenet poster
 
Posts: 1,069
Default 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