Forum Discussion
cravenyoh
Aug 25, 2021Copper Contributor
How do i differentiate between an integer or a number with decimal in a CELL using a function
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
- Aug 25, 2021
PeterBartholomew1
Aug 26, 2021Silver Contributor
Variation upon the theme:
= A₁+1 + SIGN(MOD(A₁,1))The purpose/meaning of the calculation is obscure though.