Easy one for you all...
 

....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

Easy one for you all...
 

Hi,

You only gave 1 example of your rounding criteria so how about this

=CEILING((D3*G3)*1.1,100)

Mike

"Connie Martin" wrote:

...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

Easy one for you all...
 

Thank you, Mike. That's exactly what I'm looking for. I'm totally
unfamiliar with the CEILING function, but it works! Thanks again. Connie

"Mike H" wrote:

Hi,

You only gave 1 example of your rounding criteria so how about this

=CEILING((D3*G3)*1.1,100)

Mike

"Connie Martin" wrote:

...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

Easy one for you all...
 

your welcome

"Connie Martin" wrote:

Thank you, Mike. That's exactly what I'm looking for. I'm totally
unfamiliar with the CEILING function, but it works! Thanks again. Connie

"Mike H" wrote:

Hi,

You only gave 1 example of your rounding criteria so how about this

=CEILING((D3*G3)*1.1,100)

Mike

"Connie Martin" wrote:

...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

Easy one for you all...
 

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

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