Source: images.borders.com.au
Question:
Example 1
number in cell A1 is assigned to the-4.6
I would like to retrieve 4 in 6 and cell B1 in cell C1.
Example 2
number in cell A1 is assigned to 12.86
I would like to retrieve 12 in 8 and cell B1 in cell C1.
Example 3
number in cell A1 is assigned to the-32.975
I would like to retrieve 32 9 and cell B1 in cell C1.
Anyone have suggestions?
Thanks in advance for suggestions
Answer:
C1
= INT (ABS(A1*10)-INT (ABS (A1)) * 10)
Another formula that can be used in C1...
= MOD (INT (ABS(10*A1)), 10)
Home
Add Your Article
Categories
Search Something
Latest Buzz
Related Buzz
0 Comments