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?

You answered your own question - sort of. Look at the ROUNDUP function in Excel help.

=ROUNDUP(100/18,0) = 6

=ROUNDUP(100/N75,0)*B75

Thank you, works like a charm. I'm not a power user and the syntax sometimes gets me.

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History