Excel Round up w/in calculation

May 27, 2009 at 07:37:56
Specs: Windows XP
I have a simple calculation that divides a column # by 100, then multiplies that result by another cell. It looks like: =(100/N75)*B75

The problem is that the result of the first part (100/N75) may not be a whole number and I need that result to be rounded up before the 2nd part of the formula. Example, say N75 contains the number 18 (100/18 = 5.55. I would need that 5.55 to round up to 6 and then have the next calculation done - so 100/18 - 5.55, 6*B75. I hope the question makes sense - does anyone have an answer?

See More: Excel Round up w/in calculation

Report •

May 27, 2009 at 09:12:05
You answered your own question - sort of.

Look at the ROUNDUP function in Excel help.

=ROUNDUP(100/18,0) = 6


Report •

May 27, 2009 at 18:00:37
Thank you, works like a charm. I'm not a power user and the syntax sometimes gets me.

Report •

Related Solutions

Ask Question