| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is the formula to Round an average to the nearest 100
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is the formula to Round an average to the nearest 100
=ROUND(your_formula,-2)
-- Biff Microsoft Excel MVP |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a formula to round a number to the nearest .09? | Excel Worksheet Functions | |||
| formula to round up to nearest 1,000 | Excel Discussion (Misc queries) | |||
| Round amount to nearest $10 after other formula calc. in same cell | Excel Worksheet Functions | |||
| Can a formula be set up to round to the nearest nickel? | Excel Discussion (Misc queries) | |||
| i need an excell formula that will round up to the nearest 9.99 | Excel Worksheet Functions | |||
Linear Mode
