Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding
I am looking for a rounding function that for a given set up number will
round each number to the nearest 5 increment. i.e. 1142.68,1268.05,1298.22 i would like rounded to 1140,1270 and 1300. I tried the =round() function but that just took off the decimals. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding
Try this:
=ROUND(INT(A1)/5,0)*5 -- Biff Microsoft Excel MVP "Jase" wrote in message ... I am looking for a rounding function that for a given set up number will round each number to the nearest 5 increment. i.e. 1142.68,1268.05,1298.22 i would like rounded to 1140,1270 and 1300. I tried the =round() function but that just took off the decimals. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding
What is the purpose to using the int function?
-- HTH... Jim Thomlinson "T. Valko" wrote: Try this: =ROUND(INT(A1)/5,0)*5 -- Biff Microsoft Excel MVP "Jase" wrote in message ... I am looking for a rounding function that for a given set up number will round each number to the nearest 5 increment. i.e. 1142.68,1268.05,1298.22 i would like rounded to 1140,1270 and 1300. I tried the =round() function but that just took off the decimals. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding
1142.68...would like rounded to 1140
=ROUND(A1/5,0)*5 = 1145 =ROUND(INT(A1)/5,0)*5 = 1140 I wan't sure how they wanted to treat the original value, either drop the decimal or round to the nearest integer. If you round to the nearest int then 1142.68 = 1143 rounded to the nearest 5 = 1145. So, if they *want* 1140 then you have to drop the decimal. -- Biff Microsoft Excel MVP "Jim Thomlinson" wrote in message ... What is the purpose to using the int function? -- HTH... Jim Thomlinson "T. Valko" wrote: Try this: =ROUND(INT(A1)/5,0)*5 -- Biff Microsoft Excel MVP "Jase" wrote in message ... I am looking for a rounding function that for a given set up number will round each number to the nearest 5 increment. i.e. 1142.68,1268.05,1298.22 i would like rounded to 1140,1270 and 1300. I tried the =round() function but that just took off the decimals. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding
Ding! I figured it out. I didn't notice that 1142.68 rounded down to 1140.
Dave's post clued me in to it... -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: What is the purpose to using the int function? -- HTH... Jim Thomlinson "T. Valko" wrote: Try this: =ROUND(INT(A1)/5,0)*5 -- Biff Microsoft Excel MVP "Jase" wrote in message ... I am looking for a rounding function that for a given set up number will round each number to the nearest 5 increment. i.e. 1142.68,1268.05,1298.22 i would like rounded to 1140,1270 and 1300. I tried the =round() function but that just took off the decimals. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding
Try this...
=round(a1/5, 0) * 5 -- HTH... Jim Thomlinson "Jase" wrote: I am looking for a rounding function that for a given set up number will round each number to the nearest 5 increment. i.e. 1142.68,1268.05,1298.22 i would like rounded to 1140,1270 and 1300. I tried the =round() function but that just took off the decimals. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding
Just a question/clarification...
Did you really want 1142.68 to round down to 1140? Or did you want it to round up to 1145. There's a difference in what Biff and Jim suggested. Jase wrote: I am looking for a rounding function that for a given set up number will round each number to the nearest 5 increment. i.e. 1142.68,1268.05,1298.22 i would like rounded to 1140,1270 and 1300. I tried the =round() function but that just took off the decimals. -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding
=MROUND(A2,5)
If it gives you a #NAME! error, look up MROUND in Excel help. -- David Biddulph "Jase" wrote in message ... I am looking for a rounding function that for a given set up number will round each number to the nearest 5 increment. i.e. 1142.68,1268.05,1298.22 i would like rounded to 1140,1270 and 1300. I tried the =round() function but that just took off the decimals. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
rounding | New Users to Excel | |||
Rounding | Excel Discussion (Misc queries) | |||
rounding. | New Users to Excel | |||
Rounding | Excel Worksheet Functions |