View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Puggwash Puggwash is offline
external usenet poster
 
Posts: 1
Default IF formula headache

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.