Get Decimal Precision
I need to extract the last digit of the 'Token Supply' string to check for precision errors. This helps in identifying potential rounding issues or unexpected decimal values in large datasets.
=RIGHT(B2,1) How it works: The RIGHT function extracts a specified number of characters from the end of a text string. In this scenario, `B2` refers to the cell containing the 'Token Supply' value, and `1` indicates that we want to extract only the last character (digit) of that string. This allows the Tokenomics Analyst to quickly isolate and review the final decimal place for consistency or error detection.
Data Setup
| Token Name | Token Supply |
|---|---|
| CryptoCoin | 1000.123 |
| DeciToken | 500.001 |
| PrecisionCoin | 750.5 |
| WholeCoin | 100 |
Step-by-Step Guide
Select cell C2, where you want the extracted last digit to appear.
Type the formula `=RIGHT(B2,1)` into cell C2.
Press Enter. The last digit of the token supply from cell B2 will be displayed.
Drag the fill handle (the small square at the bottom-right corner of cell C2) down to apply the formula to the rest of your 'Token Supply' data in column B.