Multiple if with criteria text

[makinmomb]

H I J K L M N O P
THIS ABBA dgy s 5301 AABB 1 THIS
THIS BABA s 5302 AABB 2 THIS
THIS ABAC aiks 4451 AABC 3
THIS CABA ls 4452 AABC 4
THIS ALBA s 3389 AABL 5 THIS
THIS BAAL s 3390 AABL 6 THIS
THIS ARBA s 2641 AABR 7 THIS
THIS ABAS bcy ehk 3391 AABS 8
THIS BAAS 3392 AABS 9
THIS YABA s 4453 AABY 10 THIS

I have this data

I need if formula to do the following logic to mark as THIS on column P

IF H = THIS
IF O = THIS
IF J = BLANK NO DATA

THEN MARK TRUE

[kasan]

Use AND()
Like this:

Please Login or Register  to view this content.

[shukla.ankur281190]

Try

=IF(AND(H1="THIS",O1="THIS",J1=""),TRUE,FALSE)

[AliGW]

The inverted commas are not needed for TRUE and FALSE:

=IF(AND(H="THIS";O="THIS";J="");TRUE;FALSE)

The OP's locale might require commas instead of semi-colons:

=IF(AND(H="THIS",O="THIS",J=""),TRUE,FALSE)

[AliGW]

The inverted commas are not needed for TRUE and FALSE:

=IF(AND(H="THIS";O="THIS";J="");TRUE;FALSE)

The OP's locale might require commas instead of semi-colons:

=IF(AND(H="THIS",O="THIS",J=""),TRUE,FALSE)

[kasan]

Well, then if() is not needed too. AND() will return boolean True or False.

Please Login or Register  to view this content.