 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2006how to make Under invoice formula
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 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  SignatureFindeo "abdurahman38@gmail.com" escribió: > Please help me how to make formula if as following case? Thank you very > much in advance to expert helpers. [quoted text clipped - 25 lines] > ============================================= > Total $50,000 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.