Greetings,
Unfortunately, aim facing a very complicated problem in excel and I need your solution please.
Briefly, if I have a product A as follows:
<tbody>
</tbody>
3 parts were withdrawn with price 100, another 5 were withdrawn with a higher price 130, then 4 PCs were Returned with what price ??? I need to automatically calculate the accurate returned price to be as follows.
<tbody>
</tbody>
Cell C4 = 118.75 = ((100*-3)+(130*-5)) / -8
Cell C5 I need the result would be 130 ( the 4 rest from the -5 at B3)
Another issue:
What if there were a lot of products as follows:
<tbody>
</tbody>
Your prompt response would be highly appreciated.
Unfortunately, aim facing a very complicated problem in excel and I need your solution please.
Briefly, if I have a product A as follows:
| Product | Qty | Price |
| A | -3 | 100 |
| A | -5 | 130 |
| A | 4 | ?? |
| A | 4 | ?? |
<tbody>
</tbody>
3 parts were withdrawn with price 100, another 5 were withdrawn with a higher price 130, then 4 PCs were Returned with what price ??? I need to automatically calculate the accurate returned price to be as follows.
| A | -3 | 100 |
| A | -5 | 130 |
| A | 4 | 118.75 |
| A | 4 | 130 |
<tbody>
</tbody>
Cell C4 = 118.75 = ((100*-3)+(130*-5)) / -8
Cell C5 I need the result would be 130 ( the 4 rest from the -5 at B3)
Another issue:
What if there were a lot of products as follows:
| Product | Qty | Price |
| A | -3 | 100 |
| A | -4 | 120 |
| B | -6 | 40 |
| C | -1 | 70 |
| D | -6 | 40 |
| B | -3 | 60 |
| A | -2 | 110 |
| C | -2 | 80 |
| B | -5 | 50 |
| B | -6 | 55 |
| B | 3 | |
| C | 6 | |
| D | 5 | |
| A | 5 | |
| A | 2 | |
| B | 5 | |
| C | 3 | |
<tbody>
</tbody>
Your prompt response would be highly appreciated.
