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

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 7:25 AM

Reply
Question marked as Best reply

Posted on Dec 31, 2022 7: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

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