Excel Help Please quick question

  • Thread starter Thread starter Tom Jacques
  • Start date Start date
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
 
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
 
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
 
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.
 
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
 
Back
Top