Z
Z
Zed2018-11-23 21:19:04
excel
Zed, 2018-11-23 21:19:04

How to hide the results of formulas in excel if no values ​​​​have been entered yet?

How to leave empty values ​​of cells where there is not yet all the data for the formula? For example, in cell E114, the correct value will be when cell D114 is filled, and it will be filled, for example, tomorrow. How to not show the values ​​of these incorrect results until the values ​​are entered in the required cells for the calculation by the formula?
5bf843690fcab204503479.jpeg

Answer the question

In order to leave comments, you need to log in

1 answer(s)
P
Pychev Anatoly, 2018-11-23
@xZedx

change the formula so that it checks the state of the cell and displays accordingly. result
for example: IF(D114="";"";D114-D109)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question