ExcelBanter - rounding

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - rounding (https://www.excelbanter.com/excel-worksheet-functions/223164-rounding.html)

Andrew Richards

rounding

Dear All,

How can I round values eg 446,,495 to nearest zero value eg: 450 or 500

thanks

--
Kind Regards,

Andrew Richards

Jarek Kujawa[_2_]

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

Mike H

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

Bob Phillips[_3_]

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

David Biddulph[_2_]

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

All times are GMT +1. The time now is 02:41 AM.