Business Objects report - If then statement

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
PdetersAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mike McCrackenSenior ConsultantCommented:
I don't know the proper syntax but something like this

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

mlmcc

PdetersAuthor Commented:
Can I have more than 1 If statement
PdetersAuthor Commented:
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

Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

PdetersAuthor Commented:
I would I get three different options/ scenarios
PdetersAuthor Commented:
This is what worked

=If([MgrApproved]="N" And [Approval Required] = "Y"; "Pending"; (If([Mgr Approved]="Y" And [Div Mgr Approval Required] = "Y"; "Approved")))

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mike McCrackenSenior ConsultantCommented:
What happened to declined?

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

mlmcc
PdetersAuthor Commented:
that is what worked
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.