Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jim
 
Posts: n/a
Default 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
  #2   Report Post  
N Harkawat
 
Posts: n/a
Default

=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   Report Post  
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Wrong answer after using the payment formula in excel punkyh New Users to Excel 8 April 28th 05 07:56 PM
edit formula bar in excel 2003? alnav89 New Users to Excel 1 April 27th 05 06:10 PM
how do I protect a formula in an excel speadsheet greg Excel Worksheet Functions 1 January 31st 05 11:29 PM
Converting an Excel formula to an Access query formula Adam Excel Discussion (Misc queries) 1 December 15th 04 03:38 AM
Excel 2003 - Formula result shows as 0:00 Serena Excel Worksheet Functions 4 November 11th 04 10:18 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"