calculation based on other entries
New to FM 10 Win XP. Trying to figure out how to auto calculate a field where there are 3 variables.
Here is what I am trying to do:
field a is number of pages
field b is number of master pages
field c is type of page (even, double or 4x
field a is user entered number
field b is what I am trying to calculate
field c is a drop down menu with the three choices (even, double or 4x)
if a = 4 pages and c= even pages then i want b to be the same result as a
if a = 4 pages and c= double pages then i want b to be 2 times the number in a
if a= 4 pages and c= 4x pages then I want b to be 4 times the number in a
Can't seem to get this figured out. Any help greatly appreciated. Sorry if I have left anything out or if not explained well. I am brand new to FMP.