Please help me how to make formula if as following case

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
 
B

Bob Phillips

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)
 
R

Ron Coderre

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
 
R

Ron Coderre

I think you interpreted that request better than I did, Bob. :)

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

XL2002, WinXP-Pro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top