,

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