Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I drag formulas from one column to the next | Excel Discussion (Misc queries) | |||
Column formulas to subtract value from value | Excel Discussion (Misc queries) | |||
Add a column with formulas | Excel Worksheet Functions | |||
Lookup last in column formulas | Excel Discussion (Misc queries) | |||
Sum of all formulas in one column? | New Users to Excel |