View Single Post
  #6   Report Post  
Harlan Grove
 
Posts: n/a
Default

"Bob Phillips" wrote...
This doesn't work for me at all, it returns 15 for 34.45.

Looking at it MOD(ABS(A1),1) evaluated to .450000000000003, which I
would take is caused by lack of precision when using MOD.

....

The motivation may have been sound. The implementation wasn't. It should be
as simple as

=LEN(x)-LEN(INT(x))-1

though that'd work with values stored and used but not displayed.

What should the result be for, say, =32+1/3?