9 Replies Latest reply on Nov 15, 2014 5:03 PM by josetorre162

    how to make multiple if statements in a calculation field




      I would like to make multiple if statements in a field calculation that reference other fields in the table.

      How can I make the calculation for example: if a field is equal to another field, the designated value is a certain formula, if a field is another diferent formula then its value is another formula. So on and so forth.

      The following picture shows, what i have so far, but it's not working if I want to add more if statements.Can you please give me some advise on how to write my calculation.Untitled.png

      Any help is appreciated. Thank you.