loan amortization issue

[lovethepirk]

I can create a loan excel sheet fast but one thing I need to learn is if the user enters 15 yrs instead of 30 I only want the cells to populate thru year 15.

Typically I create the template and pull the formulas down to year 30, if they enter 15 years all the miscellaneous cells read $0.

Not sure how to tell the program to stop populating after year 15(user input)

Thanks,

ltp

[ben_hensel]

Please Login or Register  to view this content.

Use an IF to check if the years-to-populate are less than or equal to the "max value"
TRUE: run the formula
FALSE: fill the cell with an empty text string using a pair of double quotes: ""

[lovethepirk]

I believe this is what you are mentioning....thanks for the help...

Any other way to accomplish this with any functions?

[ben_hensel]

that's... not quite what I meant (See attached).

I dunno that I've captured the arithmetic you want (because I might be changing a loan parameter, rather than a calculation-unrelated display variable) but hopefully you can see how I'm using IF() to decide whether to perform a calculation or not.

[lovethepirk]

thanks....it looks like they both are working I like the way you did it as well.

I was just curious if there was a way to not have to drop the formulas all the way to the max amount of years, ie. the program drops the formulas down that far for you based on the years inputed.