Turn points into rates, blank if missing
Turn 12.5 into 12.5%, and leave a -1 (missing) row blank.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8=-1 | Checks if the cell is -1, meaning missing. | Yes |
| 2 | A8/100 | Divides by 100 to make a rate. | Not used for row 8 |
| 3 | IF( … ) | Leaves -1 blank, otherwise uses part 2. | Blank |
A missing value stays blank, not a false rate. 12.5 becomes 0.125, shown as 12.5%.
=IF(A8=-1,"",A8/100)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 numbers. Paste percentage points into the green column of the Template tab. The rates fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Use this only when your source says -1 means missing. Anywhere else, a real -1 would turn blank.
Microsoft's help: IF function
OTHER ROUTES YOU MIGHT LIKE

Read percent text like 12.5% as numbers
12.5% as text → 12.50% as a number
Get the template →
Read percent text like 12,5% as rates
12,5% as text → 0.125
Get the template →
Turn percentage points into a rate
12.5 as points → 12.5% as a rate
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →