Forum Discussion
repeat cell answer from one cell to another
I am putting a formula in cell c20 and I want that answer to also appear in cell h4. Is there a formula that will allow me to do that?
In H4:
=C20
or, if you want H4 to look empty while C20 is still empty:
=IF(C20="", "", C20)
