How do I get a cell to show zero when calculation dies not insert a value

[ghrek]

Hi

I have this formula in a cell that calculates a difference but what im trying to do is if the calculation does not put a value in I need it to input the value of 0.00. Any ideas?

=IF(E16>E17,E16-E17,"")

 

[Joe4]

How about just changing the formula:
=IF(E16>E17,E16-E17,0)
and format to show two decimals.

If both E16 and E17 always contain numeric entries, you could also use this formula instead:
=MAX(E16-E17,0)

 

[Fluff]

Change the "" to 0