counting decimals

is there a function that if A2=12.76, another cell will =2?

Have a look in HELP index for IF

--
Don Guillett
SalesAid Software
[email protected]
"Warren Smith" <[email protected]> wrote in message
news:[email protected]...
> is there a function that if A2=12.76, another cell will =2?
>
>

Try this:

=LEN(MID(A2,FIND(".",A2)+1,25))

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"Warren Smith" <[email protected]> wrote in message
news:[email protected]...
is there a function that if A2=12.76, another cell will =2?