Sounds crazy?

Here is the data

Original Qty=175
Multiple=4
Total Rounded Qty Number=100

Original Rounded
Qty Qty
25 ?
50 ?
25 ?
75 ?
Total 175 100

I need to distribute the original quantity of 175 to add to 100 but be
multiples of 4.

I can distribute the 175 to make it add to 100 and round based on a
multiple but I dont know how to allocate the remainder to one of the
numbers.

Do I make any sense? :(

ACK!
Joe


--
wjlo
------------------------------------------------------------------------
wjlo's Profile: http://www.excelforum.com/member.php...o&userid=16264
View this thread: http://www.excelforum.com/showthread...hreadid=276657