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

In Cell D6 put this formula

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


On Nov 15, 7:13*pm, Tom Jacques <Tom
wrote:
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

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

On Nov 15, 7:13*pm, Tom Jacques <Tom
wrote:
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

"Tom Jacques" wrote:

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

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

"Tom Hutchins" wrote:

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" wrote:

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

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

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.

"Tom Jacques" wrote:

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

"Tom Hutchins" wrote:

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" wrote:

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

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

On Sun, 15 Nov 2009 06:40:01 -0800, Tom Jacques
wrote:

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

"Tom Hutchins" wrote:

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" wrote:

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