How would I modify this code to work?tells me in the first part i have to many arguements for this function. "*11*","*15*", etc.

IF(
AND(COUNTIF($AP2,"*11*","*15*","*17*","*20*","*49*","*50*", "*71*", "*72*"                                                                                                                                                                                                                                                                                                                                                                                                   ),SUM(COUNTIF($AV2:$AZ2,{"*G0480*","*G0479*","*G0477*","*G0478*","*G0481*","*G0482*","*G0483*"                                                                                                                                                                                                  }))>0),"Unable to resolve. Need InfoCode for LABOUTP. BMSD is mapped. Benefit Engine not mapped.",


How would I modify this code to work?tells me in the first part i have to many arguements for this function. "*11*","*15*", etc. I need it to work for everything listed above.

Thank you..
Culwatrnca11Data AnalystAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
Advertise Here
 
Glenn RayConnect With a Mentor Excel VBA DeveloperCommented:
Try this:
=IF(AND(SUM(COUNTIF($AP2,{"*11*","*15*","*17*","*20*","*49*","*50*","*71*","*72*"}))>0,SUM(COUNTIF($AV2:$AZ2,{"*G0480*","*G0479*","*G0477*","*G0478*","*G0481*","*G0482*","*G0483*"}))>0),"Unable to resolve. Need InfoCode for LABOUTP. BMSD is mapped. Benefit Engine not mapped.","Please Review")

You had an extra close paranthesis after the ">0" test.
0
 
Glenn RayExcel VBA DeveloperCommented:
Can you please re-type your formula exactly as it appears in your workbook?  The original post has it split up in a way that doesn't make sense.  There are no [value if true] or [value if false] arguments in your IF statement.  You're also missing a closing } in your initial COUNTIF list.

Perhaps this will work:
=IF(AND(SUM(COUNTIF($AP2,{"*11*","*15*","*17*","*20*","*49*","*50*","*71*","*72*"}))>0,SUM(COUNTIF($AV2:$AZ2,{"*G0480*","*G0479*","*G0477*","*G0478*","*G0481*","*G0482*","*G0483*"}))>0),TRUE,FALSE)

replacing TRUE, FALSE with your intended actions.


-Glenn
0
 
Culwatrnca11Data AnalystAuthor Commented:
Hi Glenn,

This is what the formula would look like.


=IF(AND(SUM(COUNTIF($AP2,{"*11*","*15*","*17*","*20*","*49*","*50*", "*71*", "*72*"}))>0),SUM(COUNTIF($AV2:$AZ2,{"*G0480*","*G0479*","*G0477*","*G0478*","*G0481*","*G0482*","*G0483*"}))>0),"Unable to resolve. Need InfoCode for LABOUTP. BMSD is mapped. Benefit Engine not mapped.","Please Review")

not working.
0
 
Culwatrnca11Data AnalystAuthor Commented:
Perfect.....  thank you Glenn for the speedy solution working perfectly.
0
 
Glenn RayExcel VBA DeveloperCommented:
You're welcome.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.