Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding Up to the 50
Are there any functions which will round numbers up to the nearest 50? eg.
50, 100, 150, 200, etc. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding Up to the 50
Supposing your number is in A1. Try the following:
=IF(A1-FLOOR(A1,50)<25,FLOOR(A1,50),CEILING(A1,50)) -- Best Regards, FARAZ A. QURESHI "Lady Excel" wrote: Are there any functions which will round numbers up to the nearest 50? eg. 50, 100, 150, 200, etc. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding Up to the 50
If you need to Round UP only then use only:
=CEILING(A1,50) -- Best Regards, FARAZ A. QURESHI "FARAZ QURESHI" wrote: Supposing your number is in A1. Try the following: =IF(A1-FLOOR(A1,50)<25,FLOOR(A1,50),CEILING(A1,50)) -- Best Regards, FARAZ A. QURESHI "Lady Excel" wrote: Are there any functions which will round numbers up to the nearest 50? eg. 50, 100, 150, 200, etc. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding Up to the 50
One way:
=ROUND(A1/50,0) * 50 In article , Lady Excel wrote: Are there any functions which will round numbers up to the nearest 50? eg. 50, 100, 150, 200, etc. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding Up to the 50
On Feb 17, 10:10*am, Lady Excel
wrote: Are there any functions which will round numbers up to the nearest 50? eg. 50, 100, 150, 200, etc. You subject line says "round up to 50", which is different from "round to the nearest 50". Which is it? One way to round to the nearest 50: =mround(A1,50) If you get a #NAME? error, use Excel Help to find information on how to use the MROUND function. Alternatively: =round(A1/50,0)*50 That also makes it easy to round up or down to a multiple of 50: =roundup(A1/50,0)*50 =rounddown(A1/50,0)*50 One of those solutions should work for you. |
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 | Excel Discussion (Misc queries) | |||
ROUNDING | New Users to Excel | |||
ROUNDING | Excel Worksheet Functions | |||
rounding | Excel Discussion (Misc queries) |