Thread: What is the formula to Round an average to the nearest 100
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default What is the formula to Round an average to the nearest 100
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" wrote in message
...
=ROUND(your_formula,-2)

--
Biff
Microsoft Excel MVP

Reply With QuoteReply With Quote