Blank Cell Formula

[Dowjd]

So I have this formula (=MAX(0,C17-C16)) that will give me a total in a cell. But the cell will always display a 0 until the calculation. How can I get the cells to be blank and only display when the calculation is made?

[JohnTopley]

Try

=IF(OR(C16="",C17=""),"",MAX(0,C17-C16))

[Dowjd]

Thanks John

That worked.