Basic FunctionsIntermediate

Round a currency conversion up to the next cent with ROUNDUP

ROUNDUP always moves away from zero to the digit you pick, no matter how small what it drops is — which is the rule an accounts-payable policy against shortchanging a payment actually needs, and ROUND cannot give it to you.

Task:

You pay a batch of supplier invoices quoted in euros, and the exchange rate for this batch sits in B1. Company policy is to always round the converted USD amount up to the next cent, never down, so the business is never short when the payment goes out. In C3, convert the euro amount in B3 to USD using the rate in B1 and round it up to two decimal places, then copy the formula down to C6.

Interactive Spreadsheet

Hints

+5 XPno-hints bonus

Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.

The data in this exercise

This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.

6 rows × 4 columns4 cells you fill in
ABCD
1Exchange rate (USD per EUR):1.0872
2Line ItemAmount (EUR)USD to Pay
3Steel brackets1248.3
4Hinges86.5
5Packing foam412.75
6Pallet wrap29.9
What this exercise teachesMay contain the answer

A straight ROUND would send Hinges' 86.50*1.0872, which comes to 94.0428, down to 94.04, because the third decimal is a 2 — correct arithmetic, but wrong for a policy that exists precisely to avoid shortchanging the payment. ROUNDUP ignores how small the remainder past the second decimal is and always pushes the cent up, landing on 94.05. Locking the rate as $B$1 keeps every row reading that same single exchange rate as the formula is copied down; without the dollar signs, the reference would slide to B2, B3 and onward, reading blank cells instead of the rate.