I think this is what you're trying to do:

=IF(A14="x","A", IF(A15="x", "T", "")

It reads, if A14 is "x" show "A", else if A15 is "x" show "T". Otherwise,
show blank.

But perhaps, VLOOKUP is what you need.. Search the help file for VLOOKUP
and you should find a good explanation and example of how to use it...


--
Hope that helps.

Vergel Adriano


"Mike" wrote:

Thanks you gave me a starting point. I did not explain my problem well. I
have a list of choices and I want it to put a different letter in another
cell if an "x" is placed in a certain box. I tried this but it does not work
for my situation

=IF(A14="x","A") =IF(A15="x","T")
--
Mike


"Mike" wrote:

I am trying to create an automatic checklist so if I put an "x" in a cell a
letter is placed in another cell in the same worksheet?

--
Mike

Sorry, Mike. Forget the VLOOKUP suggestion. It won't work in the example you
gave.

--
Hope that helps.

Vergel Adriano


"Vergel Adriano" wrote:

I think this is what you're trying to do:

=IF(A14="x","A", IF(A15="x", "T", "")

It reads, if A14 is "x" show "A", else if A15 is "x" show "T". Otherwise,
show blank.

But perhaps, VLOOKUP is what you need.. Search the help file for VLOOKUP
and you should find a good explanation and example of how to use it...


--
Hope that helps.

Vergel Adriano


"Mike" wrote:

Thanks you gave me a starting point. I did not explain my problem well. I
have a list of choices and I want it to put a different letter in another
cell if an "x" is placed in a certain box. I tried this but it does not work
for my situation

=IF(A14="x","A") =IF(A15="x","T")
--
Mike


"Mike" wrote:

I am trying to create an automatic checklist so if I put an "x" in a cell a
letter is placed in another cell in the same worksheet?

--
Mike