Forum Discussion
If function with multiple text to return a value
Hello!
I'm a novice at this. I get errors when I use this formula: =IF(T5="3960","3981","3980","3991","4020"),"River Pointe Pl.","Clubhouse Ct.")
In column T, I have different numbers and I want to be able to automatically return the "River Pointe Pl" if true and "Clubhouse Ct." if not.
Thanks
1 Reply
Use
=IF(OR(T5={"3960","3981","3980","3991","4020"}),"River Pointe Pl.","Clubhouse Ct.")
By the way, are you sure that T5 contains a text value that looks like a number? If T5 contains a 'real' number, change the formula to
=IF(OR(T5={3960,3981,3980,3991,4020}),"River Pointe Pl.","Clubhouse Ct.")
