rounding

Andrew Richards · Mar 5, 2009

Dear All,

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

thanks

Jarek Kujawa · Mar 5, 2009

=CEILING(A1,50)

Mike H · Mar 5, 2009

,

With the analysis toolpak loaded

=MROUND(A1,50)

or without

=ROUND(A1/50,0)*50

Mike

Bob Phillips · Mar 5, 2009

Not clear whether you want

=CEILING(A2,10)

or

=CEILING(A2,50)

David Biddulph · Mar 5, 2009

=ROUND(A2,-1)