Turn fraction fields into a number
Divide 3 by 4 to get 0.75, and flag a denominator of 0.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | B8=0 | Checks if the bottom number is 0. | No |
| 2 | "Review zero denominator" | What the cell says when it is 0. | Not used for row 8 |
| 3 | A8/B8 | Divides the top number by the bottom number. | 0.75 |
| 4 | IF( … ) | Uses part 2 for a 0, otherwise part 3. | 0.75 |
Dividing by 0 has no answer, so the row asks for a look instead of showing a false 0.
=IF(B8=0,"Review zero denominator",A8/B8)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 the top numbers into column A and the bottom numbers into column B 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
Check each flagged row by hand. A bottom number of 0 usually means a value is missing in the export.
Microsoft's help: IF function
OTHER ROUTES YOU MIGHT LIKE

Get the fraction part, keeping its sign
-1.5 → -0.5
Get the template →
Round values to the nearest fraction
0.26 to the nearest 1/4 → 0.25
Get the template →
Add two fractions from separate fields
1/2 + 1/4 → 0.75
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →