What is the formula to Round an average to the nearest 100
in [Functions]
|
Prev: Excel 2007 versus Excel 2003 & Excel 97-2003 fully compatible
Next: Modify general format to date format.
From: Kirsta1988 on 26 Apr 2010 18:02
From: T. Valko on 26 Apr 2010 18:14 =ROUND(your_formula,-2) -- Biff Microsoft Excel MVP
From: Ashish Mathur on 26 Apr 2010 21:42
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 > |