Results 1 to 2 of 2

Thread: Nested If Statement

  1. #1

    Nested If Statement



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Need help with a nested If Statement:
    =IF(AND(NOT(AND(OR([Country]="BR",[Country]="DE"),[Plancode]="Interim")),[AfterAdj Comm]+[After Adj Bonus]<0,[Term Date]=""),[After Adj Comm],0)

    I do not understand how to decipher the logic in the nested AND|NOT|AND|OR ...
    need help...
    thanks!

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,508
    Articles
    0
    Excel Version
    Excel 2016
    Start from the inner-most function... that is how Excel processes nested functions.

    OR(Logical1, Logical2,...)

    The checks if any of the logical statements (conditions) are True or False. If ANY one condition is TRUE then OR() returns TRUE else FALSE is returned.

    Next AND()

    AND(Logical1, Logical2,....)

    This checks if each logical statement is TRUE or FALSE. IF ALL statements are TRUE, then TRUE is returned else FALSE is returned

    Next NOT(Logical)

    This basically reverses the result of the Logical statement. So if Logical is TRUE, result is FALSE.

    Next AND()

    as above...


Posting Permissions

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