7 Replies Latest reply: Mar 12, 2018 11:46 AM by Prashant Sangle RSS

    Nested IF function

    Erica Trotter

      Hi I have a fairly basic if statement but instead of 'Yes' its coming back null, any ideas:

       

      =If(Match([Encore.Full_Name],[Workday.Full_Name]),'Yes',If(Match([Encore.Full_Name],[GLS.Full_Name]),'Yes',If(Match([Encore.Full_Name],[GLS.Full_Name]),'Yes', 'No')))