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

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | ISNUMBER(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 |
| 4 | IF( … ) | 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.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own list. Paste each notice's maximum amount into the green column of the Template tab.
- 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
OTHER ROUTES YOU MIGHT LIKE

Write a claim item-detail-subdetail path
C101 + 1 + 2 + 1 → C101 | item=1 | detail=2 | subdetail=1
Get the template →
Label a payment adjustment
-25.00 + Recovery → Payment-level adjustment: -25.00; Recovery
Get the template →
Keep payment type and outcome apart
Complete + Partial → Complete processing; payment=Partial
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →