Need help in rounding answers to nearest multiple

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
=ROUND(A1,-1) rounds A1 to the nearest multiple of 10.
Regards,
Stefi



„Wasatch†ezt írta:
 
Wasatch said:
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
Click to expand...

=MROUND(A1,10)
 
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.
 
Back
Top