Aug 25 2021 09:02 AM
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 09:07 AM
SolutionAug 25 2021 06:49 PM
@Sergei Baklan Thanks let me try
Aug 25 2021 07:16 PM
Aug 25 2021 10:47 PM
Variation upon the theme:
= A₁+1 + SIGN(MOD(A₁,1))
The purpose/meaning of the calculation is obscure though.
Aug 26 2021 05:31 AM
@cravenyoh , you are welcome
Aug 25 2021 09:07 AM
Solution