Set tiny amounts within tolerance to zero
Turn a leftover 0.004 into 0 when your tolerance is 0.01.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | ABS(A8) | The amount without its minus sign. | 0.004 |
| 2 | <=B8 | Checks it is no bigger than the tolerance. | TRUE |
| 3 | ,0, | Gives 0 when it is that small. | 0 |
| 4 | A8 | Otherwise keeps the amount as it is. | Not used for row 8 |
| 5 | IF( … ) | Picks part 3 or part 4. | 0 |
An amount exactly equal to the tolerance also becomes 0. The amounts are made-up.
=IF(ABS(A8)<=B8,0,A8)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 amounts. Paste amounts into column A and your approved tolerance into column B of the Template tab.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Use only a tolerance your team has approved. Too big a tolerance can hide real money.
Microsoft's help: ABS function
OTHER ROUTES YOU MIGHT LIKE

Round amounts to set decimal places
123.456 to 2 decimals → 123.46
Get the template →
Cut an amount to cents without rounding
1.999 → $1.99
Get the template →
Round amounts away from zero to cents
1.001 → 1.01; -1.001 → -1.01
Get the template →
Show $1,234.50 instead of 1234.5 in a mail merge
1234.5 → $1,234.50
Take this route →