Oops, sorry, missed out

A5= Kiwi
B5= 0.66667
C5= 40
A6 = Grapes
B6= 0.6667
C6= 80

Rgds


On 26 Apr 2006 16:21:06 -0700, "Richard"
wrote:

Perhaps a more generalised solution would be preferable. Try the
following

B1 = No of Cartons
C1= 70
D1= 40
B2= Carton Size (grams)
C2= 200
D2= 400
B3= Waste Factor
E3= Total Purchase Weight (Kg)
A4= Pineapple
B4= 0.66667
C4= 80
D4= 400
E4= =SUMPRODUCT(C4:D4,$C$1:$D$1)/1000*1/(1-B4)
Copy E4 down to E5 & F5

E4:E6 represents the total weight of each of your fruits.

I've assumed the waste factor is the same for each fruit, i.e. 0.6667,
but just change B4:B6 where necessary if they are different.

You might also like to put in a sum of C4:C6 and D4:D6 in say C8 & D8
just to check that the individual fruit weights add up to the carton
weight.

Hope this is useful. Next time I'm your way I'll come and sample some
:-)

Regards,

Richard Buttrey

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________