Using AND logical operator in IF statement

Hi,

I try to use a combined if statement. The result is not correct, and I think I did the formula the right way.

code in column K: =IF((AND(O2="Einbaurahmen";F2>2));1)

Thanks for the help!

Andraž

Change it to:
=IF(AND(SEARCH("Einbaurahmen",O2),F2>2),1,"Conditions not met")
Replace "Conditions not met" with what you want. THis is supposed to be in case that bhose 2 conditions are not met.

@PaulM100 what if I want to embed another IF.. I only get a result of the first cell.

when I copy I still get the errors...

code: =IF(AND(SEARCH("Einbaurahmen";O2);F2>2);1;IF(AND(SEARCH("Aluprofil ";O2);F2>3);4;0))

in my excel the comma is replaced by ";"

Try this

Please Login or Register  to view this content.

First IF condition takes in consideration if both words are present in O2, remove it if not necessary. But keep in mind that if you do so and you have both words in the same cell, then the returned value is 4 as this is the first condition. I've added first because 3 is greater than 2, so I thought that you need this first. I've also wrapped the formula in a IFERROR to sustain any issues that may occur. If you need to check the errors that do not meet the condition, then remove that part as well.

Originally Posted by apoje

code: =IF(AND(SEARCH("Einbaurahmen";O2);F2>2);1;IF(AND(SEARCH("Aluprofil ";O2);F2>3);4;0))

Try this:

=IF(COUNTIF(O2;"*Einbaurahmen*")*F2>2;1;IF(COUNTIF(O2;"*Aluprofil*")*F2>3;4;0))

@PaulM100 I tried like this and now it works

Formula:

Please Login or Register  to view this content.