>>>>Edit:
Protip>>>>The count of 2 you have to use is in the number of decimal places.
>>>>n places means divide by 2^n
>>>
>>>Clever, clever, Lutz.
>>>How did you figure that one out?
>>
>>Bill,
>>
>>simple. To much binary - hex - deci conversation
>>
>>10 is only divisible (whole numbers, as daughter says behind me) by 2 and 5
>>
>>0.1 is a tenth. A half times a fifth. IOW it's (2^-1)*(5^-1)
>>You can put one half (2^-1) into it > 0.5
>>0.01 is a tenth times a tenth, IOW (2^-1)*(5^-1)*(2^-1)*(5^-1)=(2^-2)*(5^-2)
>>You can put one quarter (2^-2) into it > 0.25; (0.5); 0.75
>>....
>>
>>There shoud be a way using LOG10() without counting numbers, but I'm to lazy right now. (For the whole part it's
INT(log10(ABS(EVL(INT(tnNumber),1))))+1 )
>
>Understood!
>Thank you.
I think I am more impressed that you understand than what he wrote :)
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham