0

I want to do a calculation with imported data from an HTML link. The data is imported every minute. There is loading time and this ensures that the cells are empty during loading. Because my formula refers to those cells, the result is "0" and this ensures that the calculations are no longer correct. Is there a way to ensure that value is taken from the cells only after it has a value (after loading) and not when it is empty during loading?

EDITOR NOTE:

From OP comment to the first answer

Only when there is a new value -> then update a cell with the new value. When it is empty (during loading) -> do nothing and keep the old value.

Import

Loading

= cell reference

0

instead of =J6 use: =IF(ISNUMBER(J6), J6, )


example: =IF(ISNUMBER(A3), A3, )

k 5

  • Thank you for your answer, unfortunately it does not work, when the cell is empty during loading, then the cell that refers to the referring cell is also empty, logical actually. So what I want: Only when there is a new value -> then update cell with the new value. When it is empty (during loading) -> do nothing and keep the old value It is difficult to explain but hopefully you understand me – Coen17st Jan 18 at 16:36
  • @Coen17st keeping the old value while loading is in progress is not possible – user0 Jan 18 at 16:47
0

Formulas using built-in methods can't keep the "old value" when a condition is meet, custom functions can't do that either. One alternative, among others, is to change a bit the way that your are using the IMPORTJSON library. Instead of using one of its custom functions, use a time-drive installable trigger to add the imported value to the spreadsheet AND to add the value of cell that depends on its result.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.