Absolute Cell Reference Problem

sugar1525

New Member
Hello Everyone:

I am new to Excel.

1. Cell C6:G6 are equivalent to 3,4,5,9,12 years respectively.
2. Cell B7:B17 are equivalent to 2%, 3%, 4%, 5%, 6%, 7%, 8%, 9%, 10%, 11%, 12% respectively.
3. Cell B3 = 25000 ( Loan Amount)
4. Forumla for cell C7 is
PMT(B7/12, C6*12, -B3) which returns
718.11

Now I have to modify the formula for cell C7 by entering absolute row & column references for all values.
I highlighted cell C7, pressed F2 to change to Edit mode and then pressed F4. Pressing F4 changes the formula to PMT(B7/12, C6*12, -\$B\$3)
After that I dragged the fill handle of cell C7 to cover all the values. But it doen not work. Don't know what I am doing wrong. It o nly works for cell D8 and values from C8:C17.
For other cells it gives #NUM!.
Can somebody tell me what I am doing wrong.

Sugar

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
The formula in C7 should be:

PMT(\$B7/12, C\$6*12, -\$B\$3)

You haven't locked the column for the interest rates and the row for the years that causing the error

HTH

Thanx so much. I see now what I was doing wrong.

Replies
9
Views
179
Replies
1
Views
369
Replies
1
Views
233
Replies
4
Views
323
Replies
1
Views
327

1,218,946
Messages
6,145,383
Members
450,613
Latest member
Chalky1982

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back