Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF function for multiple answers? | Excel Worksheet Functions | |||
Formula for rounding a column of currency to a multiple | Excel Worksheet Functions | |||
Rounding to nearest 5 cents in excel | Excel Worksheet Functions | |||
What is the formula for rounding a dollar amount to the nearest ni | New Users to Excel | |||
Rounding results to nearest quarter (in decimals) | Excel Discussion (Misc queries) |