|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?