IF formula headache
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"
--
Regards,
Tom Ogilvy
"Puggwash" wrote in message
...
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.
|