Turn fraction fields into a number

Divide 3 by 4 to get 0.75, and flag a denominator of 0.

What you'll make

In Excel: 3 and 4 becomes 0.75; 3 and 0 becomes Review zero denominator.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1B8=0Checks if the bottom number is 0.No
2"Review zero denominator"What the cell says when it is 0.Not used for row 8
3A8/B8Divides the top number by the bottom number.0.75
4IF( … )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.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. 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.
  3. 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