Results 1 to 6 of 6

Nested AND function within IF function is only addressing logical1 but not logical2

Threaded View

  1. #1
    Registered User
    Join Date
    09-12-2012
    Location
    nashville, tn
    MS-Off Ver
    Excel for Mac 2011
    Posts
    10

    Nested AND function within IF function is only addressing logical1 but not logical2

    I have a spreadsheet where I've entered this equation

    =IF(X2,'Leader Cost'!G11,IF(AND($A2<>"",AND($A2<>"First",$C2<>"Last"),AND($A2<>CoLeaderFirstName,$C2<>CoLeaderLastName)),AdminFee,"")).

    Everything functions properly except the AND($A2<>"First",$C2<>"Last".

    Just to clarify what X2 in the formula references, it's another formula that states =AND($A2=CoLeaderFirstName,$C2=CoLeaderLastName).

    If there is a name in A2 and C2, there should be an AdminFee in the cell, if I type First in cell A2 and Last in cell C2 the cell should be blank according to the formula, but when I type First in cell A2 with anything typed in C2 the cell goes blank. It looks like it is not addressing logical2 in the AND function. I'm starting to think my understanding of the order Excel processes these arguments is incorrect, so any help would be great!

    BTW, First and Last were originally LeaderFirstName and CoLeaderLastName, but I changed it to help work through what is going wrong.
    Last edited by betic; 10-20-2012 at 09:17 AM.

Thread Information

Users Browsing this Thread

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

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