How to Round Whole Numbers?
 

What is the formula for rounding whole numbers down (ie not decimals to
whole numbers)?
I want to round numbers like 14427 to 14420. The numbers are in a formula
such as:
=SUM(C6:C22)*.08 and I want to round the result to the nearest 10.
Thanks for any help.

=FLOOR(SUM(C6:C22)*.08 ,10)

--
HTH

Bob Phillips

"blank" wrote in message
...
What is the formula for rounding whole numbers down (ie not decimals to
whole numbers)?
I want to round numbers like 14427 to 14420. The numbers are in a formula
such as:
=SUM(C6:C22)*.08 and I want to round the result to the nearest 10.
Thanks for any help.

Nearest 10. use:
=ROUND((SUM(C6:C22)*.08)/10,0)*10

Your example:
=INT((SUM(C6:C22)*.08)/10)*10


- Mangesh


"blank" wrote in message
...
What is the formula for rounding whole numbers down (ie not decimals to
whole numbers)?
I want to round numbers like 14427 to 14420. The numbers are in a formula
such as:
=SUM(C6:C22)*.08 and I want to round the result to the nearest 10.
Thanks for any help.

Yes!!!!!!! Thanks very much.

"Mangesh" wrote in message
...
Nearest 10. use:
=ROUND((SUM(C6:C22)*.08)/10,0)*10

Your example:
=INT((SUM(C6:C22)*.08)/10)*10


- Mangesh


"blank" wrote in message
...
What is the formula for rounding whole numbers down (ie not decimals to
whole numbers)?
I want to round numbers like 14427 to 14420. The numbers are in a
formula
such as:
=SUM(C6:C22)*.08 and I want to round the result to the nearest 10.
Thanks for any help.