Formula Error on Amortization Schedule

I am attempting to create a clean Mortgage Amortization Schedule. What i would like the spreadsheet to do is only show the cells when column A has a value in it. For example. If you change cell B6 to 1 year, the remaining Mortgage in cell F25 is '0' and then the next row, Row 26 is blank, which is what I want throughout the entire sheet. However, Row 27 and down fills in as '#VALUE!'. I think my formula is off someplace but i don't know where. Please help.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Please comply with the moderation request. As soon as you do that, I can post an explanation and a solution.

For me, yes.

Try: A15 and copied down:

Formula:

Please Login or Register  to view this content.

Your original formula put a space in, not a blank, which is why your formulae weren't returning a blank. However, just putting a blank in causes other problems, hence using N(...)

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.