Formulas in a column
Does anyone know how to make is so that you can have a formula set up for the
entire column in an Excel sheet that doesn't show the results until there is
data entered in the corresponding column?
I am trying to do the following:
Column C is where employees can enter the specific date and column G
automatically populates for three days out ($C3+3) The problem is that once I
fill this formula all the way down it shows a date even though there is no
information filled in yet for the corresponding row.
Any thoughts? Thanks again
|