+ Reply to Thread
Results 1 to 6 of 6

Nested If/Else logic not working as desired in formula

  1. #1
    Forum Contributor
    Join Date
    07-09-2013
    Location
    Dunedin, New Zealand
    MS-Off Ver
    Excel 2016
    Posts
    105

    Nested If/Else logic not working as desired in formula

    Hi

    see attached s/sheet

    The F column is not behaving as I would expect

    On the RHS is the overall formula I am tying to replicate

    Comments please

    Bob M
    Attached Files Attached Files
    Last edited by 6StringJazzer; 10-03-2021 at 09:59 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Formulae problems

    How are you expecting the F column to behave?

    The logic you showed is more like code than a formula. It specifies results for multiple cells. You have nothing in the New Event column so I assume that is the one you need.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    The places I wrote "unspecified" means that you have not specified a result for New Event for that condition.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    07-09-2013
    Location
    Dunedin, New Zealand
    MS-Off Ver
    Excel 2016
    Posts
    105

    Re: Nested If/Else logic not working as desired in formula

    the formula I have :

    =IF(AND(F3="Upturn",E3<=I2),"Downturn",IF(AND(F3="Downturn",E3>=J2),"Upturn",""))

  4. #4
    Forum Expert
    Join Date
    09-30-2019
    Location
    Chiangmai, Thailand
    MS-Off Ver
    Office 2016, Excel 2019
    Posts
    1,234

    Re: Nested If/Else logic not working as desired in formula

    Your fomula is already worked, but we need to know how it should be calculate.

    In K3 , it's blank because

    =IF(AND(F3="Upturn",E3 < =I2),"Downturn",IF(AND(F3="Downturn",E3 > =J2),"Upturn",""))
    AND(F3="Upturn",E3 < =I2) = False
    AND(F3="Downturn",E3 > =J2) = False

    Capture.JPG

    Regards.
    Last edited by menem; 10-03-2021 at 10:41 PM. Reason: add picture

  5. #5
    Forum Contributor
    Join Date
    07-09-2013
    Location
    Dunedin, New Zealand
    MS-Off Ver
    Excel 2016
    Posts
    105

    Re: Nested If/Else logic not working as desired in formula

    F4 is my main problem

    I expect it to be "Upturn" [i.e. F3] NOT blank

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Nested If/Else logic not working as desired in formula

    ISBLANK is true if a cell is empty, despite the name. K3 is not empty. It has a formula. Use this:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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. Problems using INDIRECT formulae
    By Phil Bruton in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-10-2018, 02:00 PM
  2. VBA code to replace formulae in cells and then re-enter same formulae again after run
    By excel_msa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-20-2017, 06:56 AM
  3. [SOLVED] Formulae for golf syndicate problems x3 below, can anyone help?
    By Paul R Bentham in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-18-2013, 04:30 PM
  4. [SOLVED] Searching TEXT in formulae, rather than results of formulae
    By Niek Otten in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 03:05 PM
  5. Searching TEXT in formulae, rather than results of formulae
    By AndyE in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  6. Searching TEXT in formulae, rather than results of formulae
    By Niek Otten in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  7. formulae problems:HELP
    By stevenmorrison in forum Excel General
    Replies: 8
    Last Post: 08-11-2005, 11:26 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