Calculate a line amount to the cent

Turn a 12.345 unit price times 3 into 37.04, rounded to cents.

What you'll make

In Excel: 12.345 × 3 becomes 37.04.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The price of one item.12.345
2B8How many items. The * multiplies.37.035
3,2Keeps two decimal places, for cents.37.035
4ROUND( … )Rounds the line amount to cents.37.04

This changes the number itself, not only how it looks. Half a cent rounds away from zero. The amounts are made-up.

=ROUND(A8*B8,2)

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 amounts. Paste unit prices into column A and quantities into column B of the Template tab.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Round each line only when your source says to. Add taxes or fees separately.

Microsoft's help: ROUND function