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”)))

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

2 Answers 2

1

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

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”))) 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”))) 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")))

Your Answer

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

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