Formula Question

[Doug]

I picked up a copy of Excel and am trying to convert some AppleWorks
formula. As per previous question it does indeed allow you to calculate
the number of days between dates.

I am using an 'IF' statement. I have this forumla:
=(IF(D8>C8,(D8-C8),0)) where it enters the result or '0'. However this
fills the column with '0'. What can I put in place of '0' in the
forumla that will yield just an empty cell instead of '0'? I don't want
my columns filled with '0' I'd rather just have empty cells for a
cleaner look.

I tried substituting the address of an empty cell such as B1 but that
doesn't seem to work.

Thanks,
Doug

 

[Domenic]

Try...

=IF(D8>C8,D8-C8,"")

Hope this helps!