SOLVED

How to Extract the decimal digit from the value

Contributor

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)
Solution

Hi @ajmal pottekattil yoousuf 

 

Sans titre.png

 

One way, in C3:

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