Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel
John,
This only gives me a "T" if I put an "X" in both A14 and A15. I need each choice to place a different letter. Thanks -- Mike "John" wrote: do you mean =IF(A14="x",IF(A15="x","t","a"),"") -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|