Setting field based on two variables
Total newbie to FMP 10 on XP. Chugging along great but stuck on some calculations.
I want to set a field number based on the variables in two other fields.
I have a field for stock that gives paper weight 30,35,50 etc.
I have a field for size that gives paper size 22, 24, 26 etc.
Each combination has a different weight result which I have the calculations done for
Can I make a calculation field that says
If size is 22 and stock is 30 then weight is 34.76 and
if size is 24 and stock is 30 then weight is 37.92 and
if size is 26 and stock is 30 then weight is 41.08 and
if size is 22 and stock is 35 then weight is 36.88
And so on..
I would have 50-75 total entries for possibilities.
Better way to do this?
I want to take the result (i.e. 34.76) and use it to calculate some other fields for total lbs used etc.
Any and all help appreciated.