Easy one for you all...

[Connie Martin]

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

 

[Mike H]

Hi,

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

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

Mike

 

[RagDyeR]

Try this:

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

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


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

 

[Connie Martin]

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]

your welcome

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

 

[Ashish Mathur]

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

 

[David Biddulph]

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)