Thread: Round formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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?