How can I suppress 'FALSE' label?

[waddoguy]

I need a cell in my spreadsheet to show a "difference" value when the value in a reference cell (G25) exceeds 8. I have put the following formula in the reference cell =MIN(8,SUM(G25)) and the following formula in the "difference" cell =IF(SUM(G25)>8,SUM(G25-8)). The formulas work when there is a value in the reference cell, but when the reference cell is zero, 'FALSE' appears in the difference cell. Is there any way of getting rid of the FALSE?

 

[mikerickson]

Yes you can replace it with whatever you want

=IF(SUM(G25)>8,SUM(G25-8), "whatever you want")

If you want it blank, use ""

 

[waddoguy]

Yes you can replace it with whatever you want

=IF(SUM(G25)>8,SUM(G25-8), "whatever you want")

If you want it blank, use ""

mikerickson, thanks for your quick response. That did the trick! I used "0.00" for consistency with other cells.