can I use x in one cell and give it a value of 2 in another?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to place an x cell B35 and have C35 display 2 in it. What is the
formula I need to use?
 
hi

I'm not sure this is what you want. If so, it's very simple

Place in C35

=if(b35="x";2;"")
 
Back
Top