Round formula
=ROUND(A3,-2) will do, and that doesn't need ATP.
--
David Biddulph
"Ashish Mathur" wrote in message
...
Hi,
You may also try =mround(A3,100). For Excel 2003 and prior versions, you
would have to install the Analysis Toolpak from Tools Addins
--
Regards,
Ashish Mathur
Microsoft Excel MVP
"Khaled" wrote in message
...
How can I round 980 to 1,000?
|