Help! calculating with multiple text criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is the formula that I am trying to use to calculate. It works if there is only one thing in the H2 and J2 columns. But if there is More than that I get nothing

Can anyone help? These are text fields and h2 and j2 need to be something like H2="*0004AC*" and J2="*004103*" because there may be more than one entry in each column. They are both text fields. How can I change it so that the calculation works

=IF(AND(H2="0004AC", J2>="004103"), K22*0.7, ""

Thank you for your help
 
Assuming they are text

=IF(AND(ISNUMBER(FIND("0004AC",H2)),ISNUMBER(FIND("004103",J2))),K22*0.7,"")

or

=IF(AND(COUNTIF(H2:H2,"*0004AC*"),COUNTIF(J2:J2,"*004103*")),K22*0.7,"")

--

Regards,

Peo Sjoblom


Kel said:
This is the formula that I am trying to use to calculate. It works if
Click to expand...
there is only one thing in the H2 and J2 columns. But if there is More than
that I get nothing.
Can anyone help? These are text fields and h2 and j2 need to be something
Click to expand...
like H2="*0004AC*" and J2="*004103*" because there may be more than one
entry in each column. They are both text fields. How can I change it so
that the calculation works?
 
Back
Top