Combine a whole number and a fraction
Turn 1 and 1/2, typed as three separate numbers, into the number 1.5.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | Takes the whole number. | 1 |
| 2 | + | Adds the fraction to the whole number. | 1 + … |
| 3 | B8/C8 | Divides the top number by the bottom number. | 0.5, so 1.5 |
Excel divides before it adds, so the fraction is worked out first.
=A8+B8/C8How 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 the whole numbers, top numbers and bottom numbers into columns A to C of the Template tab. The numbers fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Type every part as 0 or more. For a negative amount like -1 1/2, add the minus sign to the result yourself.
Microsoft's help: Calculation operators in Excel
OTHER ROUTES YOU MIGHT LIKE

Turn fraction text into a number
1/2 as text → 0.5
Get the template →
Read mixed fractions like -1 1/2
-1 1/2 as text → -1.5
Get the template →
Write a count like 15 out of 20
15 and 20 → 15 out of 20
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →