Need help in rounding answers to nearest multiple
 

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

Need help in rounding answers to nearest multiple
 

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


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=558898

Need help in rounding answers to nearest multiple
 

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



€žWasatch€� ezt Ã*rta:

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

Need help in rounding answers to nearest multiple
 

MROUND.
=MROUND(A1,10)

HTH

Die_Another_Day
Wasatch wrote:
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

Need help in rounding answers to nearest multiple
 

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:

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

Need help in rounding answers to nearest multiple
 

"Wasatch" wrote in message
...
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)
--
David Biddulph

Need help in rounding answers to nearest multiple
 

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.

"Wasatch" wrote:

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