If function with multiple text to return a value

Occasional Visitor

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

@zgraves 

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.")