View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
zuri125
 
Posts: n/a
Default Adding a constant to a formula. Problems w/filling in


I am trying to find a way to "fill in" a funtion.
I have F2=E2+F1, for example. I want the cell next to it, G2, to be
=E2+G1. In other words, I want Row 2 to be the addition of E2 to each
cell in Row 1. however, when i "fill in", G2 becomes =F2+G1.
How do I make E2 a constant in the formula?


--
zuri125
------------------------------------------------------------------------
zuri125's Profile: http://www.excelforum.com/member.php...o&userid=31131
View this thread: http://www.excelforum.com/showthread...hreadid=507968