1

I keep getting an error on the following, where am I going wrong?

=IF(AND([status_pr]=”approved”,[status_sr]=”approved”,[status_dr]=”approved”),“Submission Approved”,IF(AND([status_pr]=”approved”,[status_sr]=”approved”,[status_dr]=”pending”), “Solution/Delivery Approved”,IF(AND([status_pr]=”approved”,[status_sr]=”pending”,[status_dr]=”pending”),“Pursuit Approved”,”Pending”)))

Improve this question
1
  • Have you resolved it? If yes, "accept" the helpful answer.
    – JoannaW_MSFT
    Jul 3, 2018 at 1:22

2 Answers 2

Reset to default
1

You AND operator has three operands like AND(X,Y,Z). Try changing that to AND(AND(X,Y),Z)

Improve this answer
6
  • not sure I follow?
    – user63270
    Jun 30, 2018 at 12:05
  • =IF(AND([status_pr]=”approved”, AND([status_sr]=”approved”,[status_dr]=”approved”)),“Submission Approved”,IF(AND([status_pr]=”approved”, AND([status_sr]=”approved”,[status_dr]=”pending”)), “Solution/Delivery Approved”,IF(AND([status_pr]=”approved”,AND([status_sr]=”pending”,[status_dr]=”pending”)),“Pursuit Approved”,”Pending”)))
    – Jitin Sreenivasan
    Jun 30, 2018 at 13:44
  • Try this. =IF(AND([status_pr]=”approved”, AND([status_sr]=”approved”,[status_dr]=”approved”)),“Submission Approved”,IF(AND([status_pr]=”approved”, AND([status_sr]=”approved”,[status_dr]=”pending”)), “Solution/Delivery Approved”,IF(AND([status_pr]=”approved”,AND([status_sr]=”pending”,[status_dr]=”pending”)),“Pursuit Approved”,”Pending”)))
    – Jitin Sreenivasan
    Jun 30, 2018 at 13:44
  • got the classic something went wrong with =IF(AND([status_pr]=”approved”, AND([status_sr]=”approved”,[status_dr]=”approved”)),“Submission Approved”,IF(AND([status_pr]=”approved”, AND([status_sr]=”approved”,[status_dr]=”pending”)), “Solution/Delivery Approved”,IF(AND([status_pr]=”approved”,AND([status_sr]=”pending”,[status_dr]=”pending”)),“Pursuit Approved”,”Pending”)))
    – user63270
    Jul 1, 2018 at 1:10
  • You have multiple triple and which is not valid. Fix all 3
    – Xogle
    Jul 1, 2018 at 1:58
0

The error occurs because you are using the wrong double quotation mark (”).

Change it to "

=IF(AND([status_pr]= "approved",[status_sr]= "approved",[status_dr]= "approved"),"Submission Approved",IF(AND([status_pr]= "approved",[status_sr]= "approved",[status_dr]= "pending"), "Solution/Delivery Approved",IF(AND([status_pr]= "approved",[status_sr]= "pending",[status_dr]= "pending"),"Pursuit Approved","Pending")))
Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.