IF and with *

[caliope1990]

So, I have this formula
=IF(AND(J101="ENT-apple*",M101>L101),M101-L101,0)

* is there because i have another option of ent-apple+pear.. somehow the formula is not picking up *

any suggestion?

 

[Joe4]

Welcome to the Board!

Just use:
=IF(AND(LEFT(J101,9)="ENT-apple",M101>L101),M101-L101,0)

 

[caliope1990]

thank you very much

 

[Joe4]

You are welcome!