You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

User profile for user: bofone
bofone Author
User level: 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 2:40 AM

Reply
Question marked as Top-ranking reply
User profile for user: SGIII
SGIII
User level: Level 8
36,128 points

Posted on Oct 11, 2023 2: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

1 reply

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