Hi all,

ok so i'm doing a math project, and well excel is not going to well.

I need to figure out how to do a declining balance chart....basically to represent what I have saved at a time of retirement, declining based on a monthly wage paid to myself until the time i die!

Any charts associated with the actual saving and paying out would help too.

Thanks
Ira

bump

I don't understand. Do you need help calculating the variable (meaning how much you have saved at the time of retirement) or how to make the chart of that variable?

as a practice excercise let's get a declining balance chart displaying the time it takes for the ladiez to give it up for thehidden

no no, I am fine with the whole math part. what I need to show is what I have saved declining over a period of time with a static interest rate.

chart form

old joke...used to be funny, been living with the same person for over a year now....bout time to drop it

Oh NOW you admit it used to be funny. But be careful, you've been around the internets long enough to know that "bout time to drop it" only encourages us.

Also, can anyone help with this?

can't you just use If statements to create this chart?

yeah you need a declining balance chart, speedz. hit insert, then chart, then... hold on something has come up

Probably...but I don't know how to do that...pretend that I'm totally useless with excel.



Damn you Touch!

countif

I remember I used to make fun of Ira for something, but I'm not exactly sure what it was. Something about him bragging about how many hot chicks slept with him or something? I dunno, it was something in that vein. Anybody want to track down quotes and refresh my memory? I think I could probably find out if I just search all posts by "Shimmering Wang" that contain the word "Ira," but I'm worried I'll end up with like 30 posts about retirements savings. Speaking of which, I have to make this spreadsheet....

Wang

You get help first. Somewhere in your tab (maybe at the bottom or to the side) enter in a formula: =countif(the range your stuff's in probably like A1:A51,"Y").

That gets the total number of Y's in that column. Do the same for N then make a chart. Let me know if you need more info.


So a line graph showing you have $10,000,000 at retirement going down to 0 over 20 years as you pay yourself X number of dollars a month?

We made fun of the claim that no woman had ever held out more than two dates before sleeping with him. Or was it one? I think it was two.



Thanks, ouchey already gave me a good link.

Yeah, that sounds about right. Did he post a picture of himself with two mediocre-looking women on his arm at a bar or something?

I don't think so, but maybe. If only JJJ was around to dig it up...