Support Board
Date/Time: Sat, 20 Dec 2025 00:32:06 +0000
Post From: Identifying numbers in spreadsheet programming
| [2020-02-15 04:13:09] |
| Sawtooth - Posts: 4300 |
|
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
|