SharePoint IF/AND statement

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"

Thanks
vpopperAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Shaun KlineConnect With a Mentor Lead Software EngineerCommented:
The formula syntax does not look correct. You appear to be missing an end parenthesis.

=IF(AND([Date Completed]=””,[Effective Date]=””),””,Pending”)

Don't know if that will provide you the correct results though.
1
 
vpopperAuthor Commented:
This one does not work either...thanks for trying but still need help on this one.
Thanks
0
 
vpopperAuthor Commented:
Got it - it was missing " before Pending.

Thanks
0
 
vpopperAuthor Commented:
Thanks
0
All Courses

From novice to tech pro — start learning today.