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.


MacBook Air

Posted on Dec 31, 2022 07:25 AM

Reply
Question marked as Top-ranking reply

Posted on Dec 31, 2022 07:32 AM

Use the FLOOR function, like this:




If the value to be rounded down is in A2:


=FLOOR(A2,10)


More on FLOOR here:


FLOOR - Apple Support


SG


1 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.

is there a formula to round down automatically a number with or without comma?

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