Excel Help Please quick question

[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

 

[muddan madhu]

In Cell D6 put this formula

=IF(D6="blue","yes","")

 

[muddan madhu]

oops typo !
in cell D6
=IF(D5="blue","yes","")

 

[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

 

[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

 

[muddan madhu]

=IF(D5="blue","yes",IF(D5="red","No",""))

 

[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.

 

[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