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

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

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

  • not sure I follow? – pinkstonmatt Jun 30 '18 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 '18 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 '18 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”))) – pinkstonmatt Jul 1 '18 at 1:10
  • You have multiple triple and which is not valid. Fix all 3 – Xogle Jul 1 '18 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, privacy policy and cookie policy

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