Absolute Cell Reference Problem

sugar1525

New Member
Joined
Apr 13, 2002
Messages
9
Hello Everyone:

I am new to Excel.

I have a spreadsheet where:
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.

Thanx in advance
Sugar
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

bolo

Active Member
Joined
Mar 23, 2002
Messages
423
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
 

Forum statistics

Threads
1,144,275
Messages
5,723,448
Members
422,497
Latest member
dougy99

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top