If/Or Statement Returning Incorrectly?

Topic Labels: Formulas
188 0
Showing results for 
Search instead for 
Did you mean: 
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 regardless of the selection.
IF(OR(Address="1234 Street",Address="1234 Road"),"","")
What am I doing wrong?
0 Replies 0