Hi,
I'm making an semi-automatic price calculation sheet for my production company.
In my sheet, I have a table with the names of the different machines in my factory and the hour rates (euro/hour) in a column next to it.
In column D, I have a drop down list from which I can choose the names of the machines listed in the table.
In column E, I specify the hours that this specific machine will be used.
Now, in column F, I want to calculate the price, i.e multiply the hours specified in column E with the hour rate of the machine specified in the table deppending on the value/name chosen in column D.
How can I do this?
Regards,
Steven
Bookmarks