Show a count, money or text allowance
Turn Money 1500 USD into USD 1500.00, and keep Unlimited as text, not 0.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | TEXT(B8,"0") | Writes a count as a whole number. | Not used for row 8 |
| 2 | C8&" "&TEXT(B8,"0.00") | Currency code, a space, the amount with 2 decimals. | "USD 1500.00" |
| 3 | B8&"" | Keeps words like Unlimited exactly as typed. | Not used for row 8 |
| 4 | SWITCH( … ) | Picks part 1, 2 or 3 from the value type. | "USD 1500.00" |
unsignedInt uses part 1, Money part 2, string part 3. Any other type shows Review benefit value type.
=SWITCH(A8,"unsignedInt",TEXT(B8,"0"),"Money",C8&" "&TEXT(B8,"0.00"),"string",B8&"","Review benefit value type")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 allowances. Paste each value type, its value, and the currency for Money rows into the green columns of the Template tab. The allowances fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Type each value type exactly as unsignedInt, Money or string. The values here are made-up.
Microsoft's help: SWITCH function
OTHER ROUTES YOU MIGHT LIKE

Show a cost as money or percent points
Quantity, %, 20 → 20.00%
Get the template →
Write a benefit caption with full scope
Labs + In + Family + Annual → Labs (In; Family; Annual)
Get the template →
Count visits left without hiding overuse
20 allowed, 6 used → 14 left
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →