AnsweredAssumed Answered

BOM formula: identify if ItemNo has decimal point?

Question asked by Joecel Torres on Jun 17, 2014

Hi Everyone,

 

I am trying to achieve the ff.

     Current ItemNo.

               1

               2

                2.1

               3

                3.1

                 3.1.1

              

     Desired ItemNo.

               1k

               2k

                    2.1

               3k  

                    3.1 

                     3.1.1

I want to add 'K' to the single digit ONLY.

I want to achieve this by using 'IF' on the formula but I do not know how to identify if a digit has a (decimal)point or not.

What formula/condition should I use to identify if the ItemNo has decimal point in it or none?

 

Thanks in advance!

 

 

Joecel

Outcomes