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?
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.