Rounding an amount up or down in Numbers?

Wayne:

Thank you so much for such a prompt reply. Yes, I have already used the ROUND function in this manner: ROUND (A1,-3). I’m sure you’ll know that the “–3” affects the three digits to the left of the decimal point, reducing them to zeroes. In fact, I now see that doesn’t do exactly what I wanted it to do in every example! So ignore that!

I have just trialled your solution and, respectfully, I’m just getting exactly the same result as already appears in the referred-to cell. Eg...

“ROUND (A1,2)” shows £3,151.52 which just repeats what is in Cell A1. Whereas my formula above changed it to £3,000.00 (but only because the integer contained 4 digits.)

The calculation/formula I’m after is to produce the result (in that example, “£3,151.52”) of rounding it upto £3,152.00. Ie: had the original cell shown £3,151,48, I would want it to round it downto £3,151.00.

I know I’m complicating the issue now! So may I clarify that last paragraph in laymen’s terms, or by what I remember from my days of BASIC!!, thus:

IF the two digits to the right of the decimal point are 50 or above, THEN round the number up to the next whole number. If not, then round those two digits down to 00.

Thank you, too, Foxfifth – that zero made all the difference! Does exactly what I wanted. So simple, I can’t believe I couldn’t find that in Apple’s own extensive “Functions Help” column. Of course it isthere and is the first example 😕. I had clearly long forgotten the definition of “integer” until I Googled it this afternoon (GMT) before replying to Wayne!

Thanks Wayne; I thought you must’ve made a mistake when you suggested what I was already getting! Easy to do.

While I also appreciate the further guidance you posted, I have explored Numbers basics since embarking on my task and soon discovered the extensive Help available as soon as I entered an ‘=’ sign – one of the first things I’d learned in earlier excursions. But the hints – while comprehensive and no doubt accurate for the initiated – can be bewildering to the novice. As I said earlier, I even had to remind myself what an integer was!

I just don’t do many spreadsheets but it might interest you and Foxfifth to know that I found it to be the perfect solution to my very belated attempt at writing my will ! It solves all the problems that had delayed me doing so with so many modest bequests in mind, having no direct dependents.

I was particularly pleased to have mastered percentage formalae as the best way to portion the total assets’ value and to be able to adjust it every few years as my assets diminish (or rise as with property values continuing to escalate in the UK.) Just alter that single cell’s value and see all my bequests adjust proportionately!

Highly recommended for that purpose.