Easy one for you all...

  • Thread starter Thread starter Connie Martin
  • Start date Start date
C

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
 
Hi,

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

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

Mike
 
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
 
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
 
your welcome

Connie Martin said:
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
Click to expand...
 
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
 
Back
Top