AnsweredAssumed Answered

how to make multiple if statements in a calculation field

Question asked by josetorre162 on Nov 13, 2014
Latest reply on Apr 23, 2018 by beverly



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.