Need formula help!

[kozykristi]

I have a cell, A18, that contains a cumulative total of units sold. I have another cell that I want to calculate the # of cases I'll need to order, based on the fact that there are 6 units per case. The formula I have now is =A18/6. However, it isn't calculating partials. For instance, if my figure in A18 is 13, it's showing 2 cases needed. But then I'll be one unit short. I need it to calculate a whole case even if only one unit is needed out of that case. (As in my example: one unit would be used and 5 unuesd).

I think problem is when it's rounding. If it's like this example, the figure is 13/6, or 2.1666666666. If the numbers after the decimal are less than half, or .49999999 or less, it rounds it down. I need it to round up to another case.

What to do? Does anyone have an idea about the formula I should be using?

 

[VoG]

Try

=CEILING(A18,6)/6

 

[Desu Nota from Columbus]

=if((a18/6)-int(a18/6)>0,int(a18/6)+1,int(a18/6))

 

[Desu Nota from Columbus]

VOG,

Would this formula also work? (this is the first time I have ever seen the ceiling function)

=CEILING(A18/6,1)

 

[VoG]

Yes, that also works.

 

[kozykristi]

VoG - your formula TOTALLY works...EXCELLENT!!! Thank you SO MUCH, O Great Excel Wizard!