[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 46
  • Last Modified:

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..
0
Culwatrnca11
Asked:
Culwatrnca11
  • 3
  • 2
1 Solution
 
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
 
Culwatrnca11Author 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
 
Glenn RayExcel 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
 
Culwatrnca11Author Commented:
Perfect.....  thank you Glenn for the speedy solution working perfectly.
0
 
Glenn RayExcel VBA DeveloperCommented:
You're welcome.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now