Help with IF Formula


#1

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…


#2

You have to join the conditions inside the IF with the AND function:

IF(AND(Condition1,Condition2),C)