Help

If/Or Statement Returning Incorrectly?

Topic Labels: Formulas
54 0
cancel
Showing results for 
Search instead for 
Did you mean: 
JediSherBear
4 - Data Explorer
4 - Data Explorer
I've got a single select field for an address, and I want to autofill a secondary field based on that selection
If 123 Street is selected, then it returns the corresponding email, etc.
I'm using the below formula, but it keeps returning info@email.com regardless of the selection.
 
IF(OR(Address="1234 Street",Address="1234 Road"),"Info@email.com","Info@email2.com")
 
What am I doing wrong?
0 Replies 0