A
A
Artem Morozov2019-12-22 13:00:43
excel
Artem Morozov, 2019-12-22 13:00:43

How to hide column values ​​with formula, for blank data?

Column C calculates the sum of today's value from column B, adding to it yesterday's sum from C. For example С3=C2+B3
, how to hide the values ​​of column C, for those rows whose date has not yet arrived? And that at filling of a column B they these values ​​appeared.
5dff3ce16929c308167437.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
B
Bcoon, 2019-12-22
@artem-morozov

=IF(B2="";"";C1+B2)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question