J
Justin Maxwell
STR:
  1. begin typing
    =((D2 - 74539 * FLOOR(D2 / 74539)) + 80000 * MIN(1, MAX(0, (1000 - (D2 - 74539 * FLOOR(D2 / 74539))) / 999)))
  2. observe
Actual:
Text vanishes after the second 5 (see attached gif)
Expected:
Text remains
Workaround:
Sometimes I am able to just paste the formula into the cell. But not consistently.
April 17, 2024