Turn a 2x multiplier into percent change

2x means a 100% increase, and 0.5x means a 50% decrease.

What you'll make

In Excel: 2x multiplier becomes 100% change.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1TEXTBEFORE(A8,"x")Keeps the number before the x."2"
2VALUE( … )Reads that text as a number.2
3-1Takes 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"))-1

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 multipliers. Paste text like 1.5x into the green column of the Template tab. The changes fill in by themselves.
  3. 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