<div>
<div class="content wysiwyg-content">
SharePoint Standard Calculated Field Logic handles Yes/No really well but what about three answers<br />
<br />
With the following if F05 is Yes then the value is set and all other responses are blank....<br />
=IF(F05=&quot;Yes&quot;,&quot;CEO/COO (CFO)&quot;,&quot;&quot;)<br />
<br />
What if this was the case<br />
Yes=CEO/COO (CFO)<br />
No=BG Leader<br />
Blank=Blank
</div>
</div>


SharePoint Standard Calculated Field Logic handles Yes/No really well but what about three answers

With the following if F05 is Yes then the value is set and all other responses are blank....
=IF(F05="Yes","CEO/COO (CFO)","")

What if this was the case
Yes=CEO/COO (CFO)
No=BG Leader
Blank=Blank

SharePoint Calculated Field need to hande Yes, No &amp; Blank

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.

SharePoint Calculated Field need to hande Yes, No &amp; Blank

SharePoint Calculated Field need to hande Yes, No & Blank