In Google Sheets is it possible to have the value in cell A1 to increase by 1 when the value in B1 reaches 100 and also changing the value in B1 to -100?
So for example, "120" in B1 would change the value of A1 to "1" and change the value of B1 to "20".
Basically, I am looking to use the value of A1 as a whole number and the value in B1 as the decimal place but with a max of 99 on the decimal place.
Update following request for same but with varying max decimal numbers:
CodePudding user response：
What want is not 100% able to be completed, but this is:
| A | B | C |
|---|---|---|
| 1 | 75 | 175 |
| 0 | 75 | 75 |
=IF(C1>100, LEFT(C1,1), "0") |
=IF(C1>100, RIGHT(C1, 2), C1) |
Input Number Here... |