ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel formula fill. Help needed... (https://www.excelbanter.com/excel-discussion-misc-queries/25859-excel-formula-fill-help-needed.html)

Jim

Excel formula fill. Help needed...
 
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

N Harkawat

=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





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



.



All times are GMT +1. The time now is 11:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com