Thread: multiple numeric values applied to single text
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Fam via OfficeKB.com
 
Posts: n/a
Default multiple numeric values applied to single text
Ed thank you so much. It worked.

EdMac wrote:
OK

=If(or(B2=1,B2=22,B2=13),"Residential",if(or(B2=4 5.....etc),"Commercial"

Does this help

E

--
Message posted via http://www.officekb.com
Reply With QuoteReply With Quote