How to Round Whole Numbers?

[blank]

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.

 

[Bob Phillips]

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

 

[Mangesh]

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

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


- Mangesh

 

[blank]

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

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

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


- Mangesh