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") thensubtotal = (sqinches * .18)elseif(price eq "2") thensubtotal = (sqinches * .19)elseif(price eq "3") thensubtotal = (sqinches * .20)etc...endif

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...