Make your cost per sq inch a calculation field where
cost per sq inch=
Let (x=sq inch;
Case(x>100 & x<200; 300;
x>201 & x<600; 575;
Basically this script says let x be how many square inches I have (which you calculated in the sq-in. Field). If x is between 100 and 200 then the field will be 300 (aka cost per sq in is 300). Else if x is between 201 and 600 then return 575. Else return 675. You mite want to use "greater than or equal to" signs when appropriate (the keyboard doesn't contain them so I couldn't demonstrate).
One warning about the Case function: FileMaker employs short circuit programming meaning that it stops searching once it finds a true statement. FM will read the first condition of the case function, if it is false then it will go to the next line and so on until it reaches a true statement or runs out of statements.
Thanks, I'll try this and see if it works out for me.
I appreciate your earlier reply. I have tried your suggested formula. Mine looks like this; Case(sq_in ≥ 84 & sq_in ≤ 200; 300; sq_in ≥ 201 & sq_in ≤ 600; 575). The resulting input in the cost per sq_in field always returns as 300, no matter the sq_in result. Have I missed something in revising your solution
Change & to AND.
& glues text together instead of functioning as a logical operator.
(I didn't see that myself the first time I scanned this thread. :smileywink: )