I have an Excel spreadsheet to which I am adding data on an almost daily basis. It is very simple--the variable just goes into the cells in column B and various formulas spit out results in subsequent columns. Here is the issues, in all of those other columns, I prefer that the columns remain blank until there is a number in the B cell. Right now, the formulas take an empty B cell as a 0 and go ahead a spit out a result. What can I do to keep those blank, even though the formula is there ready for data, until something is imputed?
