Pick the net or gross invoice total

Net leaves tax out and gross includes it. Pick one; never add them.

What you'll make

In Excel: 120.00 net, 129.60 gross, Net becomes 120.00.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1C8Reads 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
4SWITCH( … )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.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. 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.
  3. 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