Keep Cell Blank Until Data Entered In Referenced Cell

English
#1

I have a spreadsheet where data is to be entered into several cells in the row. Then there are formulas that
compute with that data and put the answer in that cell on the same row. However, if I copy the formula cells down the sheet so I don’t have to keep copying it, I get formula cells showing stuff I don’t want to see.

How can I keep a formula cell Blank until I have filled in the data cells that feed the formula?

#2

Hello

=IF(A1;<put your formula referencing A1 here>;"")

Hope that helps.

#3

Which also skips an explicit value of 0 in A1. If that can occur then rather

=IF(ISBLANK(A1);"";TheFormula)
#4

Thanks! I’ll give it a try.

#5

It worked great. Thanks again!

#6

Glad to help. Then please mark the answer as correct by clicking on the check mark. Thanks.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.