How to Extract the decimal digit from the value


Extract the decimal digit count.

3 Replies

@ajmal pottekattil yoousuf 

Why would 15 have a decimal count of 1? I would say it should be 0 since there is no decimal separator...

It should be zero.
mistake is happen.
best response confirmed by ajmal pottekattil yoousuf (Contributor)

Hi @ajmal pottekattil yoousuf 


Sans titre.png


One way, in C3:

=IFERROR(LEN(B3) - SEARCH(".",B3), 0)