Cross calculation question for Print Media Form

[MJ2014]

Please see eclosed diagram of my form. I offer multiple options for print media, each with their own unique price. When you select the paper type (call it "cell 1")  it automatically inserts the price in another cell (cell 2). I then need to take the total square inches (cell 3) and multiply them by the price in cell 2.

I've tried writing a script to find the value by multiplying price (which changes when the paper type is changed) by the total square inches in cell 3 but I cannot get it to work. Ideas?

[MJ2014]

Well I think I have it working now - must have been a syntax error on my part. Here is my formula if others are interested:

if (price eq "1") then

subtotal = (sqinches * .18)

elseif

(price eq "2") then

subtotal = (sqinches * .19)

elseif

(price eq "3") then

subtotal = (sqinches * .20)

etc...

endif