+ Reply to Thread
Results 1 to 2 of 2

Amortization schedule to return blank values

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    12-29-2012
    Location
    usa
    MS-Off Ver
    Excel 2016
    Posts
    325

    Amortization schedule to return blank values

    So I'm creating an amortization schedule in months, so 360 cells for a 30 year mortgage.

    What I want to do:

    Create an if statement that if the user inputs a term of say 15 years, then cells greater than 180 return a blank value.

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Amortization schedule to return blank values

    in cell B110 and so on if(B109>=180,"",....)
    instead of 180 you can reference a cell say B2 that contains the length of the loan so =if(b109>=b$2,....) the $ sign is so when copied downwards it remains the same cell
    Last edited by rcm; 04-25-2013 at 11:47 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1