<div>
I don't know the proper syntax but something like this<br />
<br />
=If([MgrApproved]=&quot;N&quot; ; if([ApprovalRequired] = &quot;Y&quot;;&quot;Pending&quot;;&quot;Declined&quot;);<wbr />&quot;Approved&quot;<wbr />)<br />
<br />
mlmcc<br />
<br />

</div>


I don't know the proper syntax but something like this

=If([MgrApproved]="N" ; if([ApprovalRequired] = "Y";"Pending";"Declined");"Approved")

mlmcc



<div>
Can I have more than 1 If statement
</div>


<div>
This is the syntax I am currently using <br />
<br />
=If([MgrApproved]=&quot;N&quot; And [ApprovalRequired] = &quot;Y&quot;;&quot;Pending&quot;;&quot;Approved&quot;)<br />
This gives me either Penidng or approved. <br />
<br />
&nbsp;What I want is 3 scenarios<br />
<br />
if YY then Approved<br />
IF NY Pending<br />
if NN declined<br />
<br />

</div>


This is the syntax I am currently using

=If([MgrApproved]="N" And [ApprovalRequired] = "Y";"Pending";"Approved")
This gives me either Penidng or approved.

 What I want is 3 scenarios

if YY then Approved
IF NY Pending
if NN declined



<div>
I would I get three different options/ scenarios
</div>


I would I get three different options/ scenarios

<div>
What happened to declined?<br />
<br />
You also changed the fields being used.<br />
My syntax probably showed you how to get the correct result<br />
<br />
mlmcc
</div>


What happened to declined?

You also changed the fields being used.
My syntax probably showed you how to get the correct result

mlmcc

<div>
<div class="content wysiwyg-content">
I am creating a Business Objects report and in one of the field I have this<br />
<br />
=If([MgrApproved]=&quot;N&quot; And [ApprovalRequired] = &quot;Y&quot;;&quot;Pending&quot;;&quot;Approved&quot;)<br />
<br />
This gives me either Penidng or approved. <br />
<br />
What I want is a third option that if if the first optin is N and the second option is N &nbsp;that I get the answer of &quot;Declined&quot;<br />
<br />
How would the If then statement go in Business Objects Report
</div>
</div>


I am creating a Business Objects report and in one of the field I have this

=If([MgrApproved]="N" And [ApprovalRequired] = "Y";"Pending";"Approved")

This gives me either Penidng or approved. 

What I want is a third option that if if the first optin is N and the second option is N  that I get the answer of "Declined"

How would the If then statement go in Business Objects Report

Business Objects report - If then statement

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.

Programming

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.