Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rounding
Dear All,
How can I round values eg 446,,495 to nearest zero value eg: 450 or 500 thanks -- Kind Regards, Andrew Richards |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rounding
=CEILING(A1,50)
On 5 Mar, 10:32, "Andrew Richards" wrote: Dear All, How can I round values eg 446,,495 *to nearest zero value eg: 450 or 500 thanks -- Kind Regards, Andrew Richards |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rounding
,
With the analysis toolpak loaded =MROUND(A1,50) or without =ROUND(A1/50,0)*50 Mike "Andrew Richards" wrote: Dear All, How can I round values eg 446,,495 to nearest zero value eg: 450 or 500 thanks -- Kind Regards, Andrew Richards |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rounding
Not clear whether you want
=CEILING(A2,10) or =CEILING(A2,50) -- __________________________________ HTH Bob "Andrew Richards" wrote in message ... Dear All, How can I round values eg 446,,495 to nearest zero value eg: 450 or 500 thanks -- Kind Regards, Andrew Richards |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rounding
=ROUND(A2,-1)
-- David Biddulph "Andrew Richards" wrote in message ... Dear All, How can I round values eg 446,,495 to nearest zero value eg: 450 or 500 thanks -- Kind Regards, Andrew Richards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding | New Users to Excel | |||
Rounding up @ 3 instead of 5 | Excel Worksheet Functions | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
Rounding | Excel Worksheet Functions | |||
Rounding | Excel Worksheet Functions |