+ Reply to Thread
Results 1 to 2 of 2

Nested IF Returning False - Need to Return True for Three Scenarios

  1. #1
    Registered User
    Join Date
    08-29-2014
    Location
    Anchorage, AK
    MS-Off Ver
    2010
    Posts
    1

    Nested IF Returning False - Need to Return True for Three Scenarios

    I have attached workbook with data. The workbook is utilizing Excel's table format formulas. I have tried to write a single formula to handle three scenarios:

    1. Remain. Life (D) > 0 and Amount to Fund Replac. (K) > 0 FALSE --- answer should be: $1,600

    2. Remain. Life (D) = 0 and Amount to Fund Replac. (K) > 0 $500 --- answer is correct

    3. Remain. Life (D) = 0 and Amount to Fund Replac. (K) = 0 FALSE --- answer should be: blank or zero

    The formula is: =IF([@[Remain. Life]]=0,IF(AND([@[Amount to Fund Replac. ]]>0),[@[Amount to Fund Replac. ]]/5,(IF([@[Remain. Life]]>0,[@[Amount to Fund Replac. ]]/[@[Remain. Life]]))))

    Any help is appreciated.

    Roger

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Nested IF Returning False - Need to Return True for Three Scenarios

    So if I am struggling with one of these I will break out a pen and piece of paper and literally draw out the diagram showing the flowchart.

    With that being said I cannot understand what your three scenarios are. What is the math for 1, 2 and 3?
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. IF Stmt Returning a TRUE FALSE Value
    By J41 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-27-2014, 08:50 AM
  2. Returning True/False/Maybe
    By RivFin in forum Excel General
    Replies: 1
    Last Post: 02-03-2011, 06:29 PM
  3. Formula for returning True (1) or False(0)
    By wish2excel in forum Excel General
    Replies: 5
    Last Post: 10-11-2010, 04:14 AM
  4. [SOLVED] Search for 2 true arguments and return true or false
    By David in forum Excel General
    Replies: 3
    Last Post: 07-15-2006, 05:20 AM
  5. Function to return True/False if all are validated as True by ISNU
    By Tetsuya Oguma in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-15-2006, 06:30 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