Results 1 to 13 of 13

Formula to Count Years Above Zero

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-18-2014
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2013
    Posts
    197

    Formula to Count Years Above Zero

    I'm calculating the future value of annuities with several variables, so the FV function isn't an option.

    This formula gives me the expected value at the end of the term:

    =H6*((1+$G$1)^C6)-$I6*(((1+$G$1)^C6)-1)/$G$1)

    In this formula, C6 is the number of years. The math works when the number stays positive, but when it goes negative I need to change the formula.

    So for those that go below zero, I need to know at what point it crosses zero. In other words, I need to count the years above zero using the above formula.


    Is this even possible?
    Last edited by phelbin; 08-26-2016 at 12:13 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Retention formula to count unique customers that made a purchase in both years
    By stu40 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-23-2016, 01:24 AM
  2. Count yes/no in years with dates given
    By tonilony in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-20-2015, 06:22 PM
  3. [SOLVED] Excel formula years service between years
    By vba1234 in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 11-25-2015, 04:19 PM
  4. [SOLVED] Using COUNT(IF(... to count number of months in years
    By Abid123 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-17-2014, 11:21 AM
  5. [SOLVED] Age based on DOB; Accounts for leap years. Years old if >2, Months if <2 years old.
    By sharpmel in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-17-2013, 04:20 PM
  6. [SOLVED] Count future years
    By Ltat42a in forum Excel General
    Replies: 2
    Last Post: 07-22-2012, 12:14 PM
  7. [SOLVED] Count Years Between Two Dates
    By sgwilliams in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-07-2011, 09:03 AM

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