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
donaldb@281.com
"Warren Smith" <cuewoz@dsl.pipex.com> wrote in message
news:xridnZ2dnZ1BOh_6nZ2dnUjzjd6dnZ2dRVnyop2dnZ0@pipex.net...
> 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" <cuewoz@dsl.pipex.com> wrote in message
news:xridnZ2dnZ1BOh_6nZ2dnUjzjd6dnZ2dRVnyop2dnZ0@pipex.net...
is there a function that if A2=12.76, another cell will =2?