Count digits before decimals and after decimals
Hi,
Why doesn't LEN help. try these
=LEN(INT(A1))
and for the decimal portion
=IF(ISERROR(FIND(".",A1)),0,LEN(A1)-FIND(".",A1))
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"Elton Law" wrote:
Dear expert,
Would like to count the digits before decimals and after decimals.
For example,
111975.35 should be 6 digits before decimals and 2 digits after decimals
12456.25 should be 5 and 2
2478.24 should be 4 and 2
248.37 should be 3 and 2
Using LEN does not help.
Can you help please?
|