Using 'AND' and 'OR' function alongwith 'IF' function

[patamey]

I am unable to give correct command in excel for a certain condition. My condition is - If a Company is Listed Company then OR even if Its a Public Company but fulfills certain criteria - the result should be "Applicable" else "Not Applicable"

The Formula I am trying is -
=IF(OR(AND($B$3="Yes"),AND($B$2="Public",$B$10>=100000000,$B$14>=1000000000,$B$20>=500000000)),"Applicable","Not Applicable")

In the above case, the Company is not Listed - but its a Public Limited Company satisfying the criteria. But it still gives output as "Not Applicable". Please help me fix the formula.

---

 

[patamey]

Similar problem guys,

The Logic is if B12= "Listed" OR B11 = "Public" AND either of B19 or B27 is greater than or equal to their respective values OR B11 = "Public" or "Private" AND either of B23 or B29 is greater than or equal to their respective values then the answer should be 'Applicable' else 'Not Applicable'.

How do I formulate this?

 

[jtakw]

Similar problem guys,

The Logic is if B12= "Listed" OR B11 = "Public" AND either of B19 or B27 is greater than or equal to their respective values OR B11 = "Public" or "Private" AND either of B23 or B29 is greater than or equal to their respective values then the answer should be 'Applicable' else 'Not Applicable'.

How do I formulate this?

Above in red, you didn't specify what values.

Give this a go:

=IF(OR(AND(OR(B12="Listed",B11="Public"),OR(B19>="respective value",B27>="respective value")),AND(OR(B11="Public",B11="Private"),OR(B23>="respective value",B29>="respective value"))),"Applicable","Not Applicable")

 

[patamey]

Its true for all other criteria. But its not returning with "Applicable" when I select "Listed"

=IF(OR(AND(OR(B12="Listed",B11="Public"),OR(B19>=500000000,B27>=250000000)),AND(OR(B11="Public",B11="Private"),OR(B23>=2000000000,B29>=1000000000))),"Applicable","Not Applicable")

 

[jtakw]

May be this is what you meant:

=IF(OR(B12="Listed",AND(B11="Public",OR(B19>="respective value",B27>="respective value")),AND(OR(B11="Public",B11="Private"),OR(B23>="respective value",B29>="respective value"))),"Applicable","Not Applicable")

Let me know.