rounding

[Andrew Richards]

Dear All,

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

thanks

 

[Jarek Kujawa]

=CEILING(A1,50)

 

[Mike H]

,

With the analysis toolpak loaded


=MROUND(A1,50)

or without

=ROUND(A1/50,0)*50

Mike

 

[Bob Phillips]

Not clear whether you want

=CEILING(A2,10)

or

=CEILING(A2,50)

 

[David Biddulph]

=ROUND(A2,-1)