Posted to microsoft.public.excel.programming

Puggwash

external usenet poster

Posts: 1

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Frequency Headache	Rothman	Excel Worksheet Functions	6	March 9th 06 09:25 PM
Vlookup Headache	Stressed Out!!	Excel Worksheet Functions	1	September 14th 05 06:03 AM
SQL Query Headache	poppy	Excel Programming	4	August 18th 04 05:10 PM
Header Headache!	CWit[_7_]	Excel Programming	10	March 4th 04 09:35 PM
Look up Headache	Chris	Excel Programming	3	November 26th 03 02:55 PM

All times are GMT +1. The time now is 06:54 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us