Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative number
This really isn't an Excel question but there are sharp people out
there that might know what I'm looking for. For a POSITIVE number (like +2, +68, +106), the value of the rightmost digit is the rightmost digit. For example: 1 = +1 2 = +2 3 = +3 etc But, for a NEGATIVE number (examples, -1, -17, -543), the value of the rightmost digit is an alphabetic- or special-character. Something like: A = -1 B = -2 C = -3 etc. What term describes this numbering-scheme? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative number
Hello,
=CHAR(56.5-(SIGN(A2)+(A2=0))*8.5+RIGHT(A2,1)) I changed your request to make the task consistent: -10 will result in "A", -1 in "B" ... Regards, Bernd |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative number
And the answer is:
Rightmost Digit Character +0 { +1 A +2 B +3 C +4 D +5 E +6 F +7 G +8 H +9 I -0 } -1 J -2 K -3 L -4 M -5 N -6 O -7 P -8 Q -9 R |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Negative Number to Postive number | Excel Worksheet Functions | |||
MROUND on a negative number. | Excel Discussion (Misc queries) | |||
How to make the cell or font color red if the number is negative? | Excel Worksheet Functions | |||
thousand separator as indian style for negative number | Excel Discussion (Misc queries) | |||
2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions |