<div>
This one does not work either...thanks for trying but still need help on this one.<br />
Thanks
</div>


This one does not work either...thanks for trying but still need help on this one.
Thanks

<div>
Got it - it was missing &quot;&nbsp;before Pending.<br />
<br />
Thanks
</div>


Got it - it was missing " before Pending.

Thanks

<div>
<div class="content wysiwyg-content">
I am trying to get this nested statement to work in SharePoint however, doesn't seem to be working. &nbsp;Any ideas?<br />
<br />
=IF(AND([Date Completed]=””,[Effective Date]=””,””,Pending”)<br />
<br />
If both are true, I want null value. &nbsp;If both are false, I want &quot;Pending&quot;<br />
<br />
Thanks
</div>
</div>


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

SharePoint IF/AND statement

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.