| 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 | |||
Hybrid Mode
