SOLVED

How do i differentiate between an integer or a number with decimal in a CELL using a function

Copper Contributor

1) If the number in the  CELL is an integer ,  I will +1 in the cell beside 

2)  If the number in the CELL is with Decimal . I will + 2 , in the CELL beside

 

Is there any function to determine 

5 Replies
best response confirmed by allyreckerman (Microsoft)

@cravenyoh 

Variation upon the theme:

= A₁+1 + SIGN(MOD(A₁,1))

The purpose/meaning of the calculation is obscure though.

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)