Need help in rounding answers to nearest multiple

[Guest]

Is there a formula or method of calculation that can be used when working
with Excel worksheets that can round the answer to the nearest multiple of
the answer, such as rounding for multiples of 10?

I am using Excel Office 2000

 

[Vito]

Try the Cieling() and Floor() functions


e.g. =Cieling(A1,10) will round up to nearest multiple of 10

=Floor(A1,10) will round down to nearest multiple of 10

 

[Guest]

=ROUND(A1,-1) rounds A1 to the nearest multiple of 10.
Regards,
Stefi



„Wasatch†ezt írta:

 

[Die_Another_Day]

MROUND.
=MROUND(A1,10)

HTH

Die_Another_Day

 

[Guest]

Hi,

try to see the tips on this site
http://www.j-walk.com/ss/excel/usertips/tip011.htm

hth
regards from Brazil
Marcelo


"Wasatch" escreveu:

 

[David Biddulph]

Is there a formula or method of calculation that can be used when working
with Excel worksheets that can round the answer to the nearest multiple of
the answer, such as rounding for multiples of 10?

I am using Excel Office 2000

=MROUND(A1,10)

 

[Guest]

I think MROUND requires an addin. Try this formula

=10*ROUND(A1/10,0)

replace both 10's with any multiple you want to round.