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.