How to make Excel not display zeros if the cell referenced by the function is empty?

Question

excel

There are n-th number of lines of the form:

=IF(A1="";"";C1)

Column A is guaranteed to have only one value, all other cells will be empty. Next, the CONCATENATE function catches the value.
If it is empty in C1, then 0 comes out in the cell with the formula, this can be defeated using the data type 0;-0;;@, but 0 still comes out in the cell with the CONCATENATE function, the type does not affect it.
It would be possible to rewrite the condition and add a value instead of a cell reference, but we are talking about several thousand values, and besides, it can change over time, so it was taken out of the conditions.

Answer 1

And if so?

=IF(A1="";"";IF(C1="";"";C1))

Answer 2

Use conditional formatting