How do I enter a formula that is gives a value if x appears in the cell?
J Jacob Skaria Nov 3, 2009 #2 If A1 is 'x' then return 1 else blank Try this in cell B1 =IF(A1="X",1,"") If this post helps click Yes
If A1 is 'x' then return 1 else blank Try this in cell B1 =IF(A1="X",1,"") If this post helps click Yes
T T. Valko Nov 3, 2009 #3 What value do you want? Try one of these... =IF(A1="x",10,0) =(A1="x")*10 =IF(A1="x","Yes","No") =IF(A1="x","Yes","")
What value do you want? Try one of these... =IF(A1="x",10,0) =(A1="x")*10 =IF(A1="x","Yes","No") =IF(A1="x","Yes","")
