Using IF to test multiple conditions
I am building a scorecard where if the value of a field changes to "N/A", I need the total to be divided by a different value (ie: total value - value of field that is set to "N/A"). However, I need t...
Forum Discussion
In a formula field you can put multiple conditions into your IF statement, eg:
Basically this says if the value of Field1 is "N/A" then divide Field2 by 5, otherwise if the value of Field1 is "Yes", then divide Field2 by 3, otherwise if the value of Field1 is "No" then divide Field2 by 10. If all the above are false then make the value 0.
All of these different criteria can be changed to suit your requirements.
IF(
[Field1] = "N/A", [Field2]/5,
[Field1] = "Yes", [Field2]/3,
[Field1] = "No", [Field2]/10,
0
)
Basically this says if the value of Field1 is "N/A" then divide Field2 by 5, otherwise if the value of Field1 is "Yes", then divide Field2 by 3, otherwise if the value of Field1 is "No" then divide Field2 by 10. If all the above are false then make the value 0.
All of these different criteria can be changed to suit your requirements.
You can do an "and" in your query, something like this:
IF([Field1]="N/A" and [Field2]=5, 20, [Field1]="N/A" and [Field2]=7, 30, [Field1]="Yes" and [Field2]=10, 50, 0)This example sets the value to 20 if Field1 is N/A and Field2 is 5, and sets the value to 30 if Field1 is N/A and Field2 is 7.