Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Group,
I are trying to fill a number of rows from a formula that is based on previously calculated data. For example, column D has values based on Column B where D3 is the sum of D2+B3. I auto filled Column D the desired number of rows and the rows filled in properly. Now, Column E is based on Column D minus a constant of 234 with the same pattern as Column D where E3 is the difference of D3-I4 (the cell with the value 234). Now, how would I fill in Column E the desired number of rows (85). Thanks, Jim |
#2
![]() |
|||
|
|||
![]()
=D3-$I$4
"Jim" wrote in message ... Group, I are trying to fill a number of rows from a formula that is based on previously calculated data. For example, column D has values based on Column B where D3 is the sum of D2+B3. I auto filled Column D the desired number of rows and the rows filled in properly. Now, Column E is based on Column D minus a constant of 234 with the same pattern as Column D where E3 is the difference of D3-I4 (the cell with the value 234). Now, how would I fill in Column E the desired number of rows (85). Thanks, Jim |
#3
![]() |
|||
|
|||
![]()
Thank you very much
-----Original Message----- =D3-$I$4 "Jim" wrote in message ... Group, I are trying to fill a number of rows from a formula that is based on previously calculated data. For example, column D has values based on Column B where D3 is the sum of D2+B3. I auto filled Column D the desired number of rows and the rows filled in properly. Now, Column E is based on Column D minus a constant of 234 with the same pattern as Column D where E3 is the difference of D3-I4 (the cell with the value 234). Now, how would I fill in Column E the desired number of rows (85). Thanks, Jim . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Wrong answer after using the payment formula in excel | New Users to Excel | |||
edit formula bar in excel 2003? | New Users to Excel | |||
how do I protect a formula in an excel speadsheet | Excel Worksheet Functions | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |