Who Knows Excel?
#21
Banned
Join Date: Nov 2010
Posts: 4,134
Originally Posted by Lneal
=-PMT($E$5/$E$6, D$9*12, $C11) this made it correct
=-PMT(E$5/E6, $D$9*E6, $C10).
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:
#23
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.
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.
#24
Banned
Join Date: Nov 2010
Posts: 4,134
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? ;-)
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? ;-)
#27
Moderator
Join Date: Jun 2008
Location: Camarillo, California
Posts: 35,242
I am testing my mod powers. let's see if I can do anything!!!!!
__________________
My newest Grandson, Caleb Austin, was born May 29th. I am now Grandma to 4 precious babies. I am so blessed!!!!
My newest Grandson, Caleb Austin, was born May 29th. I am now Grandma to 4 precious babies. I am so blessed!!!!
Thread
Thread Starter
Forum
Replies
Last Post
auntpiggylpn
General Chit-Chat (non-quilting talk)
30
08-05-2012 09:43 PM
Lneal
General Chit-Chat (non-quilting talk)
4
10-17-2010 10:54 AM