Label the maximum you may be billed

Show the notice's own amount. Never work out 20% of what Medicare paid.

What you'll make

In Excel: 48.60 becomes Source maximum you may be billed: 48.60.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1ISNUMBER(A8)Checks the notice amount is a real number.TRUE
2"Source maximum … : "&TEXT(A8,"0.00")Adds the label, then the amount with two decimals."… billed: 48.60"
3"Source maximum … not supplied"Says the amount wasn't given.Not used for row 8
4IF( … )Shows part 2 if part 1 is TRUE, else part 3."… billed: 48.60"

Read it left to right. It uses only the notice's own amount: no share of what Medicare paid is worked out. The amounts here are made-up.

=IF(ISNUMBER(A8),"Source maximum you may be billed: "&TEXT(A8,"0.00"),"Source maximum you may be billed not supplied")

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 list. Paste each notice's maximum amount into the green column of the Template tab.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

This is the notice's figure, not what the person owes. Other insurance or past payments can change the bill.

Microsoft's help: TEXT function