Y
Yara
Hi, I am doing some programming where I need to know the number of digits of
the only decimal part of a number. I ended up with the following equation:
In cell A1 I entered a decimal number.
In cell B1 I wrote the following : =LEN(A1-INT(A1))
this should give me the numbers of the decimal part.
Examples:
A1 B1
100 1
10.25 4
3.2 3
6.7 3
9.2 17 WHY? this my question.
the only decimal part of a number. I ended up with the following equation:
In cell A1 I entered a decimal number.
In cell B1 I wrote the following : =LEN(A1-INT(A1))
this should give me the numbers of the decimal part.
Examples:
A1 B1
100 1
10.25 4
3.2 3
6.7 3
9.2 17 WHY? this my question.