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;"")
 

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

Sum a license total, then vlookup to determine training cost 11
Copy formulas in defined range 4
Text from one cell in a formula in another 3
Count of leader on multiple sheets 1
Excel 2002 : Problem in moving along blank cells 10
Sumproduct accross multiple sheets 1
Check multiple cells for a match 5
INDEX/MATCH #REF! error 2

Back
Top