Hello,
I am looking to write a formula to populate a field based on two separate fields using the IF AND statement.
This would be Field 1 = A and Field 2 = B then insert C into the formula field.
Is this possible?
Thank you.
Jason…
Hello,
I am looking to write a formula to populate a field based on two separate fields using the IF AND statement.
This would be Field 1 = A and Field 2 = B then insert C into the formula field.
Is this possible?
Thank you.
Jason…
You have to join the conditions inside the IF with the AND function:
IF(AND(Condition1,Condition2),C)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.