| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round amount to nearest $10 after other formula calc. in same cell
Cell A1 contains any number, say $2,882. Cell A2 contains a formula to
calculate 10% of cell A1 (result $288.2). How do I round up cell A2 to the nearest $10 (result $290.00? I do not want to use another cell to calculate the rounding, it has to be in cell A2. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Round amount to nearest $10 after other formula calc. in same cell
Hi
Try this: =MROUND(A1/10,10) Andy. "debtors" wrote in message ... Cell A1 contains any number, say $2,882. Cell A2 contains a formula to calculate 10% of cell A1 (result $288.2). How do I round up cell A2 to the nearest $10 (result $290.00? I do not want to use another cell to calculate the rounding, it has to be in cell A2. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Round amount to nearest $10 after other formula calc. in same cell
Or to aviod the Analysis Tool Pack
=Round(A1*10%,-1) hth RES |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Can a formula be set up to round to the nearest nickel? | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
Linear Mode
