Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 19 May 2024 05:06:28 +0000
Post From: Identifying numbers in spreadsheet programming
| [2020-02-15 04:13:09] |
| Sawtooth - Posts: 4000 |
|
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
|