Support Board
Date/Time: Wed, 05 Feb 2025 00:57:33 +0000
Post From: Identifying numbers in spreadsheet programming
| [2020-02-15 04:13:09] |
| Sawtooth - Posts: 4167 |
|
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
|