I need to compute a payment based on values in 4 different fields and would like to put the result in a calculation field in the same record. I was thinking that I could create the payment field as a calculation field. The calculation is:

If field1 = "yes" then add $25 to payment field

If field2 = "yes" then add $25 to payment field

if field3 = "yes" then add $25 to payment field

if field4 = "yes" then add $50 to payment field

The calculation is cumulative. All 4 fields could be equal to "yes". If they are, then the payment field would equal $125. All Ifs need to be evaluated and only add to the payment field if the If is true. Is this possible to do in a calculation field? If so, how is it written? I have tried the above with multiple Ifs and I get an error message saying that an operator is missing.

thanks everyone.

Linda

New Payment Field =

Payment Field +

If( Field1 = "yes" ; 25 ) +

If( Field2 = "yes" ; 25 ) +

If( Field3 = "yes" ; 25 ) +

If( Field4 = "yes" ; 50 )