| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formula with multiple conditions and answers. | Excel Worksheet Functions | |||
| multiple answers | Excel Worksheet Functions | |||
| MATCH w/ multiple answers? | Excel Worksheet Functions | |||
| IF function for multiple answers? | Excel Worksheet Functions | |||
| How to create a formula with multiple contraints and answers | Excel Discussion (Misc queries) | |||
Linear Mode
