Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 75
  • Last Modified:

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
0
vpopper
Asked:
vpopper
  • 3
1 Solution
 
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now