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

[blondesherr]

=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.

 

[Niek Otten]

=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

 

[Guest]

=SUM(I6*-$I$1)+I6

-----Original Message-----
=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.

 

[Mark Griffin]

=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 &

paste, BUT I need the "I1" to ALWAYS stay "I1.