how to make different calculations depending on the field value
I am newbie to Filemaker Pro and wonder how can I implement the following:
I need to make the calculations with different values in it depending on the value in a particular field.
If value of the field X <10 then the formula would be field 1*0.5+field2*0.6+field3*0.7
If value of the field X is equal or greater than 10 and less than 20 then formula field 1*1.5 + field2*1.6+field3*1.7
If value of the field X is equal or greater than 20 and less than 100 then formula would be field 1*2.5 + field2*3.6+field3*3.7
I have tried if and case functions, but obviously I am doing omething wrong.
Your help is very appreciated.