how to make Under invoice formula

[abdurahman38]

Please help me how to make formula if as following case? Thank you very
much in advance to expert helpers.
I want divide a total amount of many diffrent product, in according to
there actual value of product of each product. as following example.
Actual invoice and value & The actual amount
Product quantity unit price total price
Bag 1000 2.1 $2,100
shoes 5000 3.1 $15,500
blanket 8000 4.32 $34,560
jacket 1500 1.8 $2,700
bed sheet 6000 6.8 $40,800
towels 3000 0.23 $690
============================================
Total $96,350

Under invoice
how to reduce (divide unit price and total amount according to each
product is actual invoice value )the total invoice amount result =
into 50000$

Product quantity unit price total price
Bag 1000 =? =?
shoes 5000 =? =?
blanket 8000 =? =?
jacket 1500 =? =?
bed sheet 6000 =? =?
towels 3000 =? =?
=============================================
Total $50,000

 

[Guest]

If your data are
A B C D
1 Product quantity unit price total
price
2 Bag 1000 2.1 $2,100
3 shoes 5000 3.1 $15,500
4 blanket 8000 4.32 $34,560
5 jacket 1500 1.8 $2,700
6 bed sheet 6000 6.8 $40,800
7 towels 3000 0.23 $690
============================================
8 Total $96,350

Then you need a total amount of $50.000 (wich is pt in $A$9). The new unit
price for each product must be calculated as follows:

New Unit Price(Product) = NewTotal / OldTotal * Old Unit Price(Product)

So, for example, for new unit price of bag:

=e$1/d$8*c2 (so, =50000/96350*2.1 =>1.09)

and the rest will bee

A B C D
10 Product quantity unit price total price
11 Bag 1000 1.09 $2,100
12 shoes 5000 1.61 $15,500
13 blanket 8000 2.24 $34,560
14 jacket 1500 0.93 $2,700
15 bed sheet 6000 3.53 $40,800
16 towels 3000 0.12 $690
============================================
17 Total $50,000

Hope this helps