Computer Forums - View Single Post

bla!! · 01-30-2008, 09:38 PM

Yup, just click on one of the cells that already has the formula in it.
Edit the formula to say

Code:

=PRODUCT(B54,D$47)

Then click and hold on the square in the lower right of the cell.

Drag down as far as you want the formula to apply. Excel will auto increment the B Value. The $ tells excel not to increment the D value.

01-30-2008, 09:38 PM	#2 (permalink)
bla!! Monster Techie Join Date: May 2004 Location: /usr/root/mn/us Posts: 1,121	Re: Amortization table in Excel Yup, just click on one of the cells that already has the formula in it. Edit the formula to say Code: =PRODUCT(B54,D$47) Then click and hold on the square in the lower right of the cell. Drag down as far as you want the formula to apply. Excel will auto increment the B Value. The $ tells excel not to increment the D value. __________________ <br> Its a frigging Laptop, not a Labtop!!!!