title: Complex if statement on a SharePoint calculated column
body: <p>I am trying to create a formula for a calculated column in SharePoint 2013
  My columns are: 
  <strong>W Certification,
  V Certification,
  Certification Sorting</strong> (This is the calculated column)
  If there are dates in both W Certification and V Certification, I want Certification Sorting to show a "3"
  If there is only a date in W Certification, Certification Sorting Should show a "1"
  If there is only a date in V Certification, Certification Sorting should show a "2"</p>
  
  <p>This is the code I have tried: =IF([W Certification]=”Not Null”,”1”,IF([V Certification]=”Not Null″,”2”,IF(and [W Certification]=”Not Null″,”)([V Certification]=”Not Null″,”3”,)))) I still receive a syntax error.</p>