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

A

Artem Morozov2019-12-22 13:00:43

excel

Artem Morozov, 2019-12-22 13:00:43

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.

Reply

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)