In Excel, I want to extract the percentile after the decimal point separately. What formula can I extract? For example: 31.1234, the number I need is 2, for example: 31.1254, the number I need is 2,

=--MID(A1,FIND(".",A1)+2,1)
Or:
=--RIGHT(INT(A1*100),1)

RELATED INFORMATIONS

1. What is the sum of 80 digits to the right of the decimal point of the quotient of 1 divided by 7
2. What is the sum of 100 digits after the decimal point of the quotient of 12 / 7
3. Please use the four numbers 2347 and the decimal point to form two, because a small number, the sum of the calculation results, can you divide this matter into several categories
4. 2,4,6,8 and the decimal point constitute two decimal places and one integer. The product of 25.68 is
5. Mathematics competition questions in Volume 2 of grade 2 (application questions, division in table, etc.) The best is people's education press
6. On the application of fractional division
7. Power operation 1.25^m÷5^m=（） 2.-y^3n+1÷y^n+1 3.(x-y)^5 X (x-y)^4= -( )^3
8. Help me work out the power set of the set! Write the power set of a = {0,2,4}
9. Proving power operation in set relation
10. If the third term of the expansion of the 9th power of (1-2) is 288, then Lim [1 / x + 1 / X & # 178; +] +1 / (n-th power of x)] =? N tends to be positive infinity
11. After the decimal point of a number is moved two places to the left, the result is 23.76 less than the original number. What is the original number? (required formula) After the decimal point of a number is moved two places to the left, the result is 23.76 less than the original number. What is the original number? (formula process required)
12. What formula does excel use to get the last digit of the decimal point
13. VB, through the formula to calculate a numerical value, how to get three decimal places, and
14. Use 3, 6, 2, 4, 5, these five numbers to form three digits multiplied by two digits, in which the largest formula is（
15. Use the five numbers 0, 4, 5, 6 and 7 to form the multiplication formula of three digit by two digit. Please write down the test of the largest product and the test of the smallest product
16. 2. 4, 6, 8... Are continuous even numbers. If the sum of five continuous even numbers is 480, what is the largest one of these five numbers To be able to read and understand
17. If there is 0 at the end of the product, the formula that can be listed is. If the product is the largest, the formula that can be listed is 0.4.6.8 if there is 0 at the end of the product, the formula that can be listed is. If the product is the largest, the formula that can be listed is. If the product is the smallest, the formula that can be listed is
18. Please fill in an even number in each box "□" in the following formula, so that the formula becomes a force, and 0,2,4,6,8 appear in the product □□□ × □□□ ＿＿＿＿＿＿＿＿ □□□□ □□□□ □□□□ ＿＿＿＿＿＿＿＿＿ □□□□□□
19. 109 8 7 6 5 4 3 21 = 1000 in "+, -, *, /, ()", pick out the appropriate symbols and fill in the numbers to make the formula true
20. Add "+" or "-" before the numbers 3, 4, 5, 6, 7, 8 and 9 to make their sum - 10. Please come up with two solutions