Thread: IF Formula Q. How do you enter multiple right answers?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default IF Formula Q. How do you enter multiple right answers?
=if(or(j2="91910", j2="91915") ,"Good","Bad")
--
HTH...

Jim Thomlinson


"KenCanuck" wrote:

Example : IF(j2="91910","Good","Bad")

How do I enter more than 1 zip code? So if I wanted 91910 and 91915
examined? Thanks!
Reply With QuoteReply With Quote