Turn a 2x multiplier into percent change
2x means a 100% increase, and 0.5x means a 50% decrease.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | TEXTBEFORE(A8,"x") | Keeps the number before the x. | "2" |
| 2 | VALUE( … ) | Reads that text as a number. | 2 |
| 3 | -1 | Takes off 1, the starting amount. | 1, shown as 100% |
2x is twice the starting amount, so the change is 1, or 100%.
=VALUE(TEXTBEFORE(A8,"x"))-1How 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 multipliers. Paste text like 1.5x into the green column of the Template tab. The changes fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Write each multiplier with a lowercase x, like 1.5x. A capital X or a plain 1.5 turns amber.
Microsoft's help: TEXTBEFORE function
OTHER ROUTES YOU MIGHT LIKE

Round a rate to chosen percent decimals
12.34560% at 2 percent decimals → 12.3500%
Get the template →
Round rates down to percent decimals
12.3456% to 2 decimals → 12.34%
Get the template →
Round rates up to percent decimals
12.3456% to 2 decimals → 12.35%
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →