Label a charge reference or billing code

Label the charge reference or the inline code, and flag a line that has both.

What you'll make

In Excel: CI-101 becomes Resolve ChargeItem reference: CI-101.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1(A8<>"")+(B8<>"")<>1Checks that not exactly one cell is filled.FALSE
2IF(A8<>"", … )Labels the reference, or else the billing code."Resolve … CI-101"
3IF( … )Flags both or neither filled, else uses part 2."Resolve … CI-101"

Read it left to right. Each filled cell counts as 1, so part 1 adds them up.

=IF((A8<>"")+(B8<>"")<>1,"Review invoice charge-item choice",IF(A8<>"","Resolve ChargeItem reference: "&A8,"Inline billing code supplied: "&B8))

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 invoice line's charge reference or inline billing code into the green columns of the Template tab. Leave the other cell empty.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

An inline code doesn't give the service date or price. Look those up in the source before writing a letter.

Microsoft's help: IF function