Posted to microsoft.public.excel.misc

KenCanuck

external usenet poster

Posts: 17

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!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
conditional formula with multiple conditions and answers.	Headacheaday	Excel Worksheet Functions	3	January 23rd 07 07:23 PM
multiple answers	AndyS	Excel Worksheet Functions	3	October 16th 06 09:14 AM
MATCH w/ multiple answers?	fastballfreddy	Excel Worksheet Functions	8	May 11th 06 06:46 AM
IF function for multiple answers?	fastballfreddy	Excel Worksheet Functions	3	April 30th 06 08:11 PM
How to create a formula with multiple contraints and answers	torky1	Excel Discussion (Misc queries)	6	March 5th 05 07:36 AM

All times are GMT +1. The time now is 05:52 AM.

About Us

"It's about Microsoft Excel"