Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
Try this. =MROUND(D3*G3*1.1,100) If you are using any version other than Excel 2007, you will need to install the Analysis Toolpak from Tools Addins for the MROUND() function to work -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Connie Martin" wrote in message ... ...but not for me. I can do it on a calculator, but not in Excel. This is what I'm trying to do: the sum of (D3*G3) + 10%. The numbers a D3 = 21.6, G3 = 100, so the answer should come to 2,376. And then I want to round up that number to become 2,400. Thank you. Connie |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
You could avoid the need for ATP by changing =MROUND(D3*G3*1.1,100) to
=ROUND(D3*G3*1.1,-2) The OP did, however, want to round *up*, so =ROUNDUP(D3*G3*1.1,-2) or =CEILING(D3*G3*1.1,100) -- David Biddulph Ashish Mathur wrote: Hi, Try this. =MROUND(D3*G3*1.1,100) If you are using any version other than Excel 2007, you will need to install the Analysis Toolpak from Tools Addins for the MROUND() function to work "Connie Martin" wrote in message ... ...but not for me. I can do it on a calculator, but not in Excel. This is what I'm trying to do: the sum of (D3*G3) + 10%. The numbers a D3 = 21.6, G3 = 100, so the answer should come to 2,376. And then I want to round up that number to become 2,400. Thank you. Connie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
This has to be easy. | Charts and Charting in Excel | |||
pls help, is there an easy way to | Excel Worksheet Functions | |||
Should be easy how to | Excel Worksheet Functions | |||
I'm sure this is an easy one, but.... | Excel Worksheet Functions | |||
new user with easy question? not easy for me | New Users to Excel |