| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter formula and fill down
How can I enter a formula into cell E2 and then fill the formula down to the
last row with data on the sheet. For example: enter into E2: =IF(D20,TODAY()-(D2+30)," ") Fill into E3: =IF(D30,TODAY()-(D3+30)," ") ....Fill to last Row on sheet with data in column D. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My worksheet automatically adds a fill color when I enter text. | Excel Discussion (Misc queries) | |||
| Enter a value in wks1-Find that value on wks2-Auto fill cells in w | Excel Worksheet Functions | |||
| i want cells to auto fill with colour when i enter a number | Excel Discussion (Misc queries) | |||
| What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. | Excel Worksheet Functions | |||
| Enter last name, auto fill full name & address--HOW? | Excel Discussion (Misc queries) | |||
Threaded Mode
