=ROUND(your_formula,-2)
A Ashish Mathur Apr 27, 2010 #2 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
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