Formula Help- Need (1) number to stay the same

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=SUM(I6*-I1)+I6
In this formula, I need the I6 to "roll" when I copy & paste, BUT I need the "I1" to ALWAYS stay "I1.

Please help.
 
=SUM(I6*-I1)+$I$6

You can toggle between relative, partial relative and absolute addressing by
putting the cursor in the address in the formula bar, and press F4
repeatedly. 4 Possibilities present themselves.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
=SUM(I6*-$I$1)+I6
-----Original Message-----
=SUM(I6*-I1)+I6
In this formula, I need the I6 to "roll" when I copy &
Click to expand...
paste, BUT I need the "I1" to ALWAYS stay "I1.
 
=SUM(I6*-$I$1)+I6
$ character holds the column or row.
-----Original Message-----
=SUM(I6*-I1)+I6
In this formula, I need the I6 to "roll" when I copy &
Click to expand...
paste, BUT I need the "I1" to ALWAYS stay "I1.
 
Back
Top