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

Cheers, Pete

-----Original 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.
.