From: Kirsta1988 on

From: T. Valko on
=ROUND(your_formula,-2)

--
Biff
Microsoft Excel MVP


From: Ashish Mathur on
Hi,

You may try this

=MROUND(E9,100)

In Excel 2003 and prior versions, you will need to install the Analysis
Toolpak for the MROUND() to work

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"T. Valko" <biffinpitt(a)comcast.net> wrote in message
news:ugb7R3Y5KHA.4644(a)TK2MSFTNGP02.phx.gbl...
> =ROUND(your_formula,-2)
>
> --
> Biff
> Microsoft Excel MVP
>