Formulas in a column

  • Thread starter Thread starter ~genevieve
  • Start date Start date
G

~genevieve

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
 
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.
 
OR the below which will even look for 0s entered in C3

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

If this post helps click Yes
 
I did not know that but i know it will be very useful in the future. Thank
you for that one.
 
Back
Top