2 Replies Latest reply on Dec 4, 2010 3:52 AM by NataljaBaskirova

    how to make different calculations depending on the field value

    NataljaBaskirova

      Title

      how to make different calculations depending on the field value

      Post

      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.

      For example:

      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

      etc, etc

      I have tried if and case functions, but obviously I am doing omething wrong.

      Your help is very appreciated.