This will no doubt be blindingly obvious to anyone who knows anything, but it's not to me, and I need to know...
It's easier if I explain in terms of the actual need I think: I have a spreadsheet in which I am costing a set of classes. As new students sign up, the number of students increases (obv), but the number of classes increases only when a certain number is reached. So if we have a maximum of 16 students per class, 35 students = 3 classes, 40 students = 3 classes, 45 students = 3 classes, but 50 students = 4 classes.
The question is how do I make a cell do that kind of staggered increase?
It's easier if I explain in terms of the actual need I think: I have a spreadsheet in which I am costing a set of classes. As new students sign up, the number of students increases (obv), but the number of classes increases only when a certain number is reached. So if we have a maximum of 16 students per class, 35 students = 3 classes, 40 students = 3 classes, 45 students = 3 classes, but 50 students = 4 classes.
The question is how do I make a cell do that kind of staggered increase?
Comment