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

Formulas in a column
 

Hello,

What i would do is, in cell G3 update your formula to =if(C3="","",C3+3)
then if cell C3 was blank G3 will also be blank. Then you can copy the
formula down to the rest of the column.
--
Kevin Smith :o)


"~genevieve" wrote:

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

Formulas in a column
 

OR the below which will even look for 0s entered in C3

=IF(C3,C3+3,"")

If this post helps click Yes
---------------
Jacob Skaria


"~genevieve" wrote:

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

Formulas in a column
 

I did not know that but i know it will be very useful in the future. Thank
you for that one.
--
Kevin Smith :o)


"Jacob Skaria" wrote:

OR the below which will even look for 0s entered in C3

=IF(C3,C3+3,"")

If this post helps click Yes
---------------
Jacob Skaria


"~genevieve" wrote:

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