Rounding

[traff1982]

Hi everyone

I'm trying to round an answer to the nearest 12th but am not really confident as to how to go about it. Any help would be great.

Cheers

 

[Andrew Poulsom]

Like this?

=ROUND(A1*12,0)/12

 

[traff1982]

thanks, but that formula would round my answer to the nearest 0 then divide it by 12, as opposed to rounding my answer to the nearest 12th.

 

[Andrew Poulsom]

That formula multiplies your answer by 12 before rounding to zero places. Then it divides that value by 12, resulting in the answer rounded to the nearest 12th.

 

[doco]

Going to have some problems with this because 1/12 = .0833333... but this should get you close

=ROUND(E12/(1/12),3)*(1/12)
=CEILING(E12,0.083)    '    Round up

Also see http://www.mrexcel.com/archive/Formulas/index.html Then scroll down to 'Rounding' in the index list. There are numerous threads on the subject there.

HTH

 

[barry houdini]

=ROUND(E12/(1/12),3)*(1/12)

Hello doco,

This formula won't round to the nearest 1/12, it'll round to the nearest 1/12000

Andrew's suggested formula will do the job.....or using MROUND function from Analysis ToolPak addin (unless you have Excel 2007, in which case it's a native function)

=MROUND(A1,1/12)