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?
 
Shaun KlineLead 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.