Return nth decimal number
This tutorial shows how to extract the nth decimal number using an Excel formula, with the MID and FIND functions
Hard coded formula
Cell reference formula
GENERIC FORMULA
=MID(number,FIND(".",number)+nth_decimal,1)
ARGUMENTS GENERIC FORMULA
=MID(number,FIND(".",number)+nth_decimal,1)
ARGUMENTS EXPLANATION This formula uses the FIND function to return the position of a full stop from a number and then adds a number that represents the nth decimal number that you want to return. The MID function is then used to return the number with a position calculated by the FIND function.
Click on either the Hard Coded or Cell Reference button to view the formula that has the nth decimal number and the number from which you want to return the nth decimal number directly entered into the formula or referenced to specific cells. |
RELATED TOPICS
Related Topic | Description | Related Topic and Description |
---|---|---|
Return first decimal number | How to extract the first decimal number | |
Return last decimal number | How to extract the last decimal number |
RELATED FUNCTIONS
Related Functions | Description | Related Functions and Description |
---|---|---|
FIND Function | The Excel FIND function returns the position of a specific sub-string within a string | |
MID Function | The Excel MID function returns the specified number of characters from a selected string, starting at a specified position |