Rounding
Ding! I figured it out. I didn't notice that 1142.68 rounded down to 1140.
Dave's post clued me in to it...
--
HTH...
Jim Thomlinson
"Jim Thomlinson" wrote:
What is the purpose to using the int function?
--
HTH...
Jim Thomlinson
"T. Valko" wrote:
Try this:
=ROUND(INT(A1)/5,0)*5
--
Biff
Microsoft Excel MVP
"Jase" wrote in message
...
I am looking for a rounding function that for a given set up number will
round each number to the nearest 5 increment. i.e. 1142.68,1268.05,1298.22
i
would like rounded to 1140,1270 and 1300. I tried the =round() function
but
that just took off the decimals.
|