Hi newbie here!
I'm building a pricing sheet in excel and want to be able to enter a code for one of my products and have it automatically calulate the final cost depending on size
I have built a sheet so when I type in cell A3, 10" and B3, 8" . C3 calulates the total size =36" (10 + 8 X 2)
Now i need to create a cell (lets say D3 ) that will when I enter my frame code (JPW/L277) will give this code a monetary value per unit ( 2.40 per inch) So I can then
create a formular in cell E3 that will multiply C3 X D3 = 86.40
any ideas?
mark
I'm building a pricing sheet in excel and want to be able to enter a code for one of my products and have it automatically calulate the final cost depending on size
I have built a sheet so when I type in cell A3, 10" and B3, 8" . C3 calulates the total size =36" (10 + 8 X 2)
Now i need to create a cell (lets say D3 ) that will when I enter my frame code (JPW/L277) will give this code a monetary value per unit ( 2.40 per inch) So I can then
create a formular in cell E3 that will multiply C3 X D3 = 86.40
any ideas?
mark