I am trying to get this nested statement to work in SharePoint however, doesn't seem to be working. Any ideas?
=IF(AND([Date Completed]=””,[Effective Date]=””,””,Pending”)
If both are true, I want null value. If both are false, I want "Pending"