Day 82 · Saturday, 24 October 2026

From the archive

Intermediate

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.

The daily challenge is part of Pro

A new exercise every morning, plus every day that came before it — a back catalogue that grows by one a day, whether or not you were here for it.

Every day so far

August 2026

September 2026

October 2026

November 2026

18
SolvedOpenProLatest

Recent days

The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.