Support Board
Date/Time: Tue, 04 Nov 2025 13:40:08 +0000
[Programming Help] - Identifying numbers in spreadsheet programming
View Count: 633
| [2020-02-15 01:44:41] |
| User917679 - Posts: 76 |
|
Is there a study that can "speak to" the identity of a number(for spreadsheet programming)? For instance, if I have the price 9886, is there something I can use that can determine whether the last digit is a "5", and if so, then "abc etc" |
| [2020-02-15 04:13:09] |
| Sawtooth - Posts: 4285 |
|
Try this: =VALUE(RIGHT(TEXT(VALUE(E3)),1))=5 This makes E3 a value, makes it a text string, than counts from the right 1 character and returns that character, then makes that character a number, then compares it to 5. Date Time Of Last Edit: 2020-02-15 04:23:20
|
| [2020-02-15 06:12:20] |
| User917679 - Posts: 76 |
|
Will definitely try this; Thanks a ton |
| [2020-02-15 14:05:20] |
| User917679 - Posts: 76 |
|
"=VALUE(RIGHT(TEXT(VALUE(E3)),1))=5" One quick question here though: If I had 9886.5, would I now have to use RIGHT "2" to go two characters over and reach the "6"? |
| [2020-02-15 15:52:23] |
| Sawtooth - Posts: 4285 |
|
You'd have to use RIGHT "3" because the decimal point is a position.
|
To post a message in this thread, you need to log in with your Sierra Chart account: