Level 1

4 points

Formula in NUMBERS

Hi

I'd like to know how to round a number for example 18002 to 18000

Thanks

Posted on Oct 11, 2023 02:40 AM

Reply

Top-ranking reply

Level 8

37,202 points

Posted on Oct 11, 2023 02:59 AM

If 18002 is in cell B2 then try =MROUND(B2,1000)

More on MROUND here:

MROUND - Apple Support (HK)

Depending on what you are trying to do you may also find the following useful.

ROUNDUP - Apple Support (HK)

ROUNDDOWN - Apple Support (HK)

CEILING - Apple Support (HK)

FLOOR - Apple Support (HK)

SG

View in context

Similar questions

is there a formula to round down automatically a number with or without comma? i'd like the formula to take the value from a cell (for example A1) and round that number down (B1) if A1 is 229, the value of B1 has to be 220 if A1 is 373.20, B1 is 370 i'm not that good with this stuff so i don't know if it's possible to do something like this.
299 1

1 reply

Top-ranking reply

Level 8

37,202 points

Oct 11, 2023 02:59 AM in response to bofone

If 18002 is in cell B2 then try =MROUND(B2,1000)

More on MROUND here:

MROUND - Apple Support (HK)

Depending on what you are trying to do you may also find the following useful.

ROUNDUP - Apple Support (HK)

ROUNDDOWN - Apple Support (HK)

CEILING - Apple Support (HK)

FLOOR - Apple Support (HK)

SG

Reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Formula in NUMBERS

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up