Easy one for you all...
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
|