View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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