Please help me how to make formula if as following case

  • Thread starter Thread starter Rehman
  • Start date Start date
R

Rehman

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
 
Unit is

=C2*50000/SUM($D$2:$D$7)

Prtice is

=D2*50000/SUM($D$2:$D$7)


and copy down for others


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
See if this is what you're looking for:

With your data in Cells A1:D8

D2: =B2/SUM($B$2:$B$7)*$D$8
Copy down through D7

C2: =+D2/B2
Copy down through C7

That will allocate the total price of $50,000 amoung the products according
to their quantity percentage of the total of the quantities.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
I think you interpreted that request better than I did, Bob. :)

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Back
Top