Pick the net or gross invoice total
Net leaves tax out and gross includes it. Pick one; never add them.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | C8 | Reads the tax basis asked for. | "Net" |
| 2 | "Net",IF(ISNUMBER(A8),A8, … ) | Net: uses the net total, or says it's absent. | 120.00 |
| 3 | "Gross",IF(ISNUMBER(B8),B8, … ) | Gross: uses the gross total, or says it's absent. | Not used for row 8 |
| 4 | SWITCH( … ) | Uses the part that matches the basis. | 120.00 |
Read it left to right. Any other basis says Review requested tax basis.
=SWITCH(C8,"Net",IF(ISNUMBER(A8),A8,"Source net total absent"),"Gross",IF(ISNUMBER(B8),B8,"Source gross total absent"),"Review requested tax basis")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 totals. Paste the net total, the gross total and the basis asked for into the green columns of the Template tab. The basis is Net or Gross.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Take Net or Gross from the request itself. A gross total isn't the amount the patient still owes.
Microsoft's help: SWITCH function
OTHER ROUTES YOU MIGHT LIKE

Sign invoice amounts by type
discount 25.00 → -25.00
Get the template →
Pick a charge description by its source
Reference + Lab panel → Lab panel
Get the template →
Label a charge reference or billing code
CI-101 → Resolve ChargeItem reference: CI-101
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →