Timeline for Converting Letter Results into numbers using a formula
Current License: CC BY-SA 3.0
3 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Dec 19, 2016 at 15:33 | comment | added | Jeff Zeitlin |
His original erroneous IF() did use -1, 0, 1, but his text asked for 0, 1, 2. To get -1, 0, 1, he'd just need to do an additional subtraction of 1 afterward: =((SEARCH(A1,"WTATAB")-1)/2)-1
|
|
Dec 17, 2016 at 11:33 | comment | added | kolcinx | This is very interesting solution. Just note the OP wanted -1,0,+1 values. | |
Dec 16, 2016 at 13:10 | history | answered | Jeff Zeitlin | CC BY-SA 3.0 |