= if X=1

  • Thread starter Thread starter Gen
  • Start date Start date
G

Gen

How do I enter a formula that is gives a value if x appears in the cell?
 
If A1 is 'x' then return 1 else blank

Try this in cell B1
=IF(A1="X",1,"")

If this post helps click 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","")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set non-continuous PrintArea via Function / Name 0
Cell reference in formula string displays abbreviated value 2
Scrabble Value calculation for Welsh words 0
SUMIF "value if false" not working 2
Index Match Problem 3
Finding the weighted average of text that have been given values 1
Index and Match 2
multiple if statment 2

Back
Top