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
5 Replies
- PeterBartholomew1Silver Contributor
Variation upon the theme:
= A₁+1 + SIGN(MOD(A₁,1))The purpose/meaning of the calculation is obscure though.
- SergeiBaklanDiamond Contributor
- cravenyohCopper Contributor
SergeiBaklan Thanks let me try
- cravenyohCopper Contributorit works !! Thank you ...