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