| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
can I use x in one cell and give it a value of 2 in another?
I want to place an x cell B35 and have C35 display 2 in it. What is the
formula I need to use? |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
hi I'm not sure this is what you want. If so, it's very simple Place in C35 =if(b35="x";2;"") -- pmguerra ------------------------------------------------------------------------ pmguerra's Profile: http://www.excelforum.com/member.php...o&userid=14986 View this thread: http://www.excelforum.com/showthread...hreadid=475026 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can excel give value in words of number entered in another cell? | Excel Worksheet Functions | |||
| how to give cell reference using Combo Boxes in Excel? | Excel Discussion (Misc queries) | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| How do I delete the "=" from a cell to give me the phone number I. | Excel Discussion (Misc queries) | |||
| entering a26-02 into a cell give strange result | Excel Discussion (Misc queries) | |||
Linear Mode
