need help to solve this

Giganews Newsgroups
Subject: need help to solve this
Posted by:  klaengur (klaengur.27il3y_1147134600.5921@excelforum-nospam.com)
Date: Mon, 8 May 2006

Ím trying to get excel to solve this for me!
I have a small table that can look something loke this!

box type #  -    min kg      -  max kg
4            -      20      -    110
5            -      20      -    80
6            -      300      -    500

then i want to be able to distribute total weight among boxes

example:
I have a total weight of 1000 kg
I have two number 6 boxes
I have one number 4 box and
I have one number 5 box

So I want excel to disibute the wiegth among all boxes
solution:
-----------------------
box 6  = 450
box 6  = 410
box 5  = 60
box 4  = 80
-----------------------
total 1000 kg
-----------------------

I've been trying to use vlookup and randbetween

need help to compleat this.
:confused:

--
klaengur
------------------------------------------------------------------------
klaengur's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34253
View this thread:http://www.excelforum.com/showthread.php?threadid=540101

Replies