Excel Help Please quick question

T

Tom Jacques

i want to have a cell automatically fill its self in when another cell says a
certain thing.

eg - if i type "blue" into D5 i want D6 to automatically change to "yes"

Is this possible

Thanks
 
T

Tom Hutchins

Put this in D6:

=IF(D5="blue","yes","no")

"no" in this example is what D6 will show if D5 does NOT contain "blue"

Hope this helps,

Hutch
 
T

Tom Jacques

Thanks for the reply Hutch,

Can this work with multiple ones, like if D5 said blue it would change D6 to
yes if it said Red then it would change D6 to No etc

Thanks again
 
S

Sheeloo

Yes, you can..
=IF(D5="blue","Yes",IF(D5="red","No","Neither Yes nor No"))

In Excel 2003 you can have upto 7 IF nested like the two above.

You should use VLOOKUP if you have many conditions.
 
G

Gord Dibben

Depends upon how many conditions are included in "etc."

May have to use a VLOOKUP formula if more than 7


Gord Dibben MS Excel MVP
 
Top