In Microsoft Excel, How do I give Words numerical value?

Question

Example: ON = 1
OFF = 0

Answer 1

You have to put this if condition

goto b1 cell and put this formula =if(a1="ON",1,if(a1="OFF",0,"EMPTY"))

if you can't read full formula please move your mouse pointer over it. then it will be displayed full.

so when you put ON in a1 cell, that will display 1 and when you put OFF b1 cell will display 0 if a1 cell remains empty, then b1 will display "EMPTY"

Answer 2

1. Insert | Name | Define
2. Type On in the top field (Names in workbook) and type 1 in the bottom field (refers to)
3. Click Add

Then do the same thing for Off. After that, you can use either one in formulae as variables. Not sure how long ago I learned this, but it has worked for me at least since Office 95.

Answer 3

Don't know. But while in Excel hit F1 for help and search. Or click on Help and then Microsoft Excel Help.

Answer 4

write a macro that uses either the IF(..) or SELECT CASE... statements to map the word values to a number, then call that macro in cells that you need the numeric values.

Answer 5

use if statement and put " on 1 example "1" and format that into other column

Answer 6

um, the help menu?