Forum Discussion

ajmal_pottekattil_yoousuf

Iron Contributor

Dec 05, 2022

Solved

How to Extract the decimal digit from the value

Extract the decimal digit count.

Extract the resolution.xlsx9 KB

Lorenzo
Dec 05, 2022
Hi ajmal_pottekattil_yoousuf

One way, in C3:
=IFERROR(LEN(B3) - SEARCH(".",B3), 0)

3 Replies

Lorenzo
Silver Contributor
Dec 05, 2022
Hi ajmal_pottekattil_yoousuf

One way, in C3:
=IFERROR(LEN(B3) - SEARCH(".",B3), 0)
HansVogelaar
MVP
Dec 05, 2022
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...
- ajmal_pottekattil_yoousuf
  Iron Contributor
  Dec 05, 2022
  It should be zero.
  mistake is happen.

Resources