= if X=1

Gen · Nov 3, 2009

How do I enter a formula that is gives a value if x appears in the cell?

Jacob Skaria · Nov 3, 2009

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. Valko · Nov 3, 2009

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","")