Lenght of a decimal part of a number.

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.
 
H

Harlan Grove

Yara said:
Hi, I am doing some programming where I need to know the number of
digits of the only decimal part of a number. . . . ....
In cell B1 I wrote the following : =LEN(A1-INT(A1))
....

Use

=LEN(ABS(A1))-LEN(INT(ABS(A1)))-(A1<>INT(A1))

instead.
 
R

Rick Rothstein \(MVP - VB\)

Hi, I am doing some programming where I need to know the number of
Use

=LEN(ABS(A1))-LEN(INT(ABS(A1)))-(A1<>INT(A1))

instead.

Here is a shorter formula which also appears to work...

=MAX(0,LEN(A1)-FIND(".",A1&"."))

Rick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top