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