ExcelBanter - IF Formula Q. How do you enter multiple right answers?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF Formula Q. How do you enter multiple right answers? (https://www.excelbanter.com/excel-discussion-misc-queries/158183-if-formula-q-how-do-you-enter-multiple-right-answers.html)

KenCanuck

IF Formula Q. How do you enter multiple right answers?

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

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

Jim Thomlinson

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!

All times are GMT +1. The time now is 02:11 AM.