View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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