I'm creating an ordering form for a photograph printing business with Adobe Acrobat 10. The concept is that the user will input data for each photograph individually - file name, paper size and paper type into cells in a table and a fourth column will calculate the price.
The paper size and paper type are drop down menus, Paper Size with 4 Options and Paper Type having 3 Options, so 12 combinations all with different prices.
I want a cell in the fourth column of each row to calculate the price based on the options the user has selected, but cannot reach this using addition/multiplication etc.
I have the concept that i need to write an IF statement with multiple conditions as in Excel but am not familiar with JavaScript and so need some help!
Thank you in advance!