Results 1 to 7 of 7

need formula to show positive withdrawal as "0"

Threaded View

  1. #1
    Registered User
    Join Date
    06-13-2013
    Location
    Charleston, SC
    MS-Off Ver
    Excel 2010
    Posts
    75

    need formula to show positive withdrawal as "0"

    I am finishing up a retirement calculator and have the situation where my formula is computing how much of the 401K withdrawal to subtract from the beginning 401k balance the next year. As an example, my beginning 401K balance in year 2 = end 401K balance year 1 minus 401k withdrawal in year 1. This works fine for years when there is an actual withdrawal. I am showing my withdrawals as (negative numbers) and "adding" that column back as described.

    The problem is that in years where annual income exceeds retirement withdrawal needed, it computes a POSITIVE withdrawal. I do not know how to adjust the formula to add another condition so that when r21>0, it should not be added.

    column g= end 401k balance
    column r = 401k withdrawal
    yr1= line 21

    beg 401k balance yr2(line 22)=IF(ISNUMBER(R21),(G21+R21),G21)

    Thanks

    Screenshot attached.
    HR
    Attached Files Attached Files
    Last edited by hmr2662; 04-03-2014 at 10:04 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 01-02-2014, 02:15 PM
  2. Replies: 9
    Last Post: 11-06-2012, 08:59 AM
  3. Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" not working
    By redders in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2011, 03:52 PM
  4. Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  5. [SOLVED] conditional formula to show "open" or "closed"
    By SBS in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-27-2006, 09:50 PM

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