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

[dk]

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

[pmguerra]

hi

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

Place in C35

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

[Dave Peterson]

In C35:
=if(b35="x",2,"whateveryouwanthere")


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

--

Dave Peterson