MTS

Why are the answers correct?

Because the formulas are correct. Not pretty, but correct.

-The rate is calculating off the same cells even though the $$ are different,

-The #payments is also calc correctly even though you have 12 in one and E6 in the other. As the value in E6 is 12.......see?

-And as you're referencing the correct PV/loan amounts, each formula would calculate correctly - C10 and C11.

A little tip:
Sometimes, with convoluted formulas - and this isn't even half bad - I will go to the cell with the forumla, EDIT and put a ' in front to make it a label. That way I can really study it, instead of looking up at the bar on top. To make it a formula again, just delete the '.

Try this formula:
=-PMT($E$5/$E$6,D$9*12,$C11)

This should copy correctly.
I'm assuming row 9 has the #years.

The difference to your first one is that you locked in BOTH the column and the row to figure your rate, but not in the second.
So if you copied the first one, you'd be ok because I'm assuming that's the ONLY place you the 6.5% and 12.
However, if you copy your 2nd one, that formula is going to shift depending on where you move it.

So since the data only appears in those 2 cell on your spreadsheet, you have to LOCK those locations.

And I don't mind helping, but all that information in your second post would have been helpful in the first post.
Saves everyone time. ;-) :thumbup:

Lneal

Thanks so Much for your help again! I just needed a genius in Excel to explain it :D :D I am getting it though, just takes longer for a 54yr old going to college.

:thumbup:

Lneal

Oh I hope someone can help! :D

I am now working with charts in excel and I don't understand this problem........... I am told to insert a data table without legend keys below a 3-D chart. I am asked to do this so the reader is not confused about the relative sizes of the different columns. My question is how do I get that information?

I followed the directions to use the Data Table button in the Labels group on the Chart Tools Layout tab. I am not getting a data table.

MTS

I'm assuming you've already made the chart.

Right click on the chart area.
Select Chart Options
Tab next to Data Labels is Data Table.
Click on Data Table.
Click on "Show Data Table"

Click on Legend Tab
Remove check for Show Legend

In a perfect world, this should display the data table but not the legend.

Personally, I think this is visually more confusing than the legend.
But what do I know? ;-)

Lneal

Got it! :thumbup: :thumbup:

MTS

Glad to hear it! :thumbup: :thumbup:

Until next time......;-)

Jim's Gem

I am testing my mod powers. let's see if I can do anything!!!!!