Excel Auto Price Rounding

I already have a workbook in Excel 2016 that converts a list of product prices from USD to my local currency when I type the daily exchange rate and press a “Recalculate” button. What’s missing is the final clean-up step: the converted figures need to round automatically according to two rules I use in our catalog.

• Any converted price that lands in the hundreds (three-digit result) must round to the next ten ─ for example 102.21 should show as 110.
• Any converted price that reaches four or more digits must round to the next hundred ─ 9189.29 should become 9200.

All prices share the same exchange rate and they’re laid out across several columns, so the rounding logic has to recognise every numeric cell in those columns and apply the correct rule in one click, without me editing each column manually. When I change tomorrow’s rate and press the button again, the sheet should recalculate and re-round flawlessly.

Deliverable
A fully working solution embedded in the existing file—this can be an improved formula approach, a VBA routine tied to the current button, or a mix of both—as long as it is:

• Compatible with Excel 2016.
• Respectful of my two rounding standards above, no matter how many rows I add later.
• Self-contained; I should be able to send the workbook to a colleague and have the button behave the same way on their machine.

If you’re confident handling conditional rounding logic and tidy VBA/formula automation, I’d love to wrap this up quickly.