Sign Up ›
  • Chris Picking
  • NEWBIE
  • 10 Points
  • Member since 2014
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
SOLVED
2 replies

Combine IF statements

I'm trying to take this statment and then add the second block so that it all works together, but no matter how I try it I get syntax errors of varying types.  
IF(Desired_Record_Type__c = "Lead", 
IF(NOT(isBlank(SSN__c)) || (NOT(isBlank(First_Name_Override__c )) && NOT(isBlank(LastName)) && (NOT(isBlank(Mobile_Phone_Override__c )) || NOT(isBlank(Primary_Email_Override__c)))), true, false ), IF(NOT(isBlank(LastName)) && (NOT(ISBLANK(Mobile_Phone__c)) || (NOT(isBlank(Email)) && NOT(isBlank(Brand__c))) || (NOT(isBlank(Email)) && NOT(isBlank(Company)))), true, false ) )
  
IF(Desired_Record_Type__c = "Prospect",  
IF(NOT(isBlank(First_Name_Override__c  )) && NOT(isBlank(LastName)),  true,  false  ), IF(NOT(isBlank(LastName)) && (NOT(ISBLANK(Mobile_Phone__c)) || (NOT(isBlank(Email)) && NOT(isBlank(Brand__c))) || (NOT(isBlank(Email)) && NOT(isBlank(Company)))),  true,  false  ) )


Any help on combining the two would greatly be appreciated.