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