Write a zero-balance label

Turn a balance that rounds to 0.00 into Zero balance. Others show as $1,234.50.

What you'll make

In Excel: 0.004 becomes Zero balance.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1ROUND(A8,2)=0Checks whether the balance rounds to zero cents.Yes
2"Zero balance"The words to show for a zero balance."Zero balance"
3TEXT(A8,"$#,##0.00")Writes other balances with $, commas and cents.Not used for row 8
4IF( … )Picks Zero balance or the written amount."Zero balance"

A balance under half a cent, like 0.004, counts as zero. Negative balances keep their minus sign. The amounts are made-up.

=IF(ROUND(A8,2)=0,"Zero balance",TEXT(A8,"$#,##0.00"))

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own balances. Paste balances, as numbers, into the green column of the Template tab. The results fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Zero balance only describes this one cell. Check for other charges before telling someone they owe nothing.

Microsoft's help: IF function