Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help me how to make formula if as following case
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help me how to make formula if as following case
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) "Rehman" <u18078@uwe wrote in message news:5ae53f7438429@uwe... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help me how to make formula if as following case
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 "Rehman" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help me how to make formula if as following case
I think you interpreted that request better than I did, Bob. :)
*********** Regards, Ron XL2002, WinXP-Pro "Bob Phillips" wrote: 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) "Rehman" <u18078@uwe wrote in message news:5ae53f7438429@uwe... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Code | Excel Discussion (Misc queries) | |||
How to .. | Excel Discussion (Misc queries) | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
reminder notifications in a column | Excel Discussion (Misc queries) | |||
convert value in word. For Exampe Rs.115.00 convert into word as . | Excel Discussion (Misc queries) |