You need to sign in to do that
Don't have an account?
Daniel Bedard
Complex IF Statements
I am trying to write a, IF statement in a formula that will evaluate as follows:
If field A is greater than or equal to 27 OR either field B OR field C are greater than or equal to 610, AND field D is equal to MG-UG, return the value of Option1” otherwise go to the next criteria and so on.
Below is what I used. It did not return a syntax error but it also did not work. I suspect the issue to be in the “either” part of the formula.
IF(Highest_ACT_Composite__c >= 27 || ((Highest_SAT_I_Verbal__c >=610 ||(Highest_ERWS__c >=610)) && (Contains("MG-UG",(Student_Rec_Major_Code_1__c)))),"Business Math",
Any insights would be greatly appreciated.
If field A is greater than or equal to 27 OR either field B OR field C are greater than or equal to 610, AND field D is equal to MG-UG, return the value of Option1” otherwise go to the next criteria and so on.
Below is what I used. It did not return a syntax error but it also did not work. I suspect the issue to be in the “either” part of the formula.
IF(Highest_ACT_Composite__c >= 27 || ((Highest_SAT_I_Verbal__c >=610 ||(Highest_ERWS__c >=610)) && (Contains("MG-UG",(Student_Rec_Major_Code_1__c)))),"Business Math",
Any insights would be greatly appreciated.
Is it an AND ?
So - is it stated like this? Basicall - just one OR...
IF(Highest_ACT_Composite__c >= 27 ||
((Highest_SAT_I_Verbal__c >=610 || Highest_ERWS__c >=610) &&
(Contains("MG-UG",(Student_Rec_Major_Code_1__c))))
)
,"All is True", "All is False"
)
or.... - is it like this?
IF((Contains("MG-UG",(Student_Rec_Major_Code_1__c))) &&
(Highest_ACT_Composite__c >= 27 || ((Highest_SAT_I_Verbal__c >=610 || Highest_ERWS__c >=610))),
"All is True", "All is False"
)
See the difference?