I have a basic+ knowledge on Excel, but my problem is a little bit complicated and I would appreciate your help!I have a table, with names of products, next to each product their amount and their price. That table, have to be edible from the user (but this on a second time). Next, there is another table, where the user, can select from a drop down list the name of the product that he wants. Then, under that, he puts the amount of that product ex.300. Now... my problem are the calculations.. I want, when the user select the name of the product, see it's amount and price and find out how it will be the price on the amount the user put.. Example: If the user select the C material and needs 300 amount, I want to make automate a calculation with method of three.
On 960 amount it has 1.66€. On 300 amount, how much?? ->
(300 * 1.66) / 960 = 0.52€ I put also an image if that make it easier to understand it..