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

D

dk

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

pmguerra

hi

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

Place in C35

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