IF formula headache

[Guest]

I am trying to set up a formula in IF to calculate a figure into what I call
'STACKS' and BASKETS'. if I have a total of 6000 and I need to know how many
STACKS and BASKETS i need how do I do this. I can get STACKS but I cannot get
the difference if it shows 22.67 STACKS. How do I get the .67 converted into
Baskets.
STACKS = 9 high and product in a BASKET = 18.
Any help would be greatful.

 

[Pete McCosh]

Have a look at the MOD function, which returns the
remainder after division.

Cheers, Pete

 

[Mike Fogleman]

If your answer is in cell D16, then put this in cell E16 -

RIGHT(D16)

That will equal the number of baskets in .67 stacks.

Mike F

 

[Tom Ogilvy]

If a stack is 9 baskets of 18 items each then I get

total = 6000
? int(total/(9*18))
37 ' stacks
? total mod (9*18)
6 ' remaining products

to get 22 2/3 stacks, I would need 3672 products

total = 3672
? int(total/(9*18))
22 ' stacks
? (total mod (9*18))
108 ' 108 remainin products
? (total mod (9*18))/18
6 ' makes 6 baskets

for a formula if you total product count is in F6

=TRUNC(F6/(9*18)) & " Stacks and " & TRUNC(MOD(F6,(9*18))/18) & " baskets
with a remainder of " & MOD(F6,18) & " products"