I need a formula that will give me results as follows:

If S1=Bank and E1 or F1=L, 1,0

The response to S1 must be Bank, but either E1 or F1 can be L to count as 1.
Both E1 and F1 don't have to meet the condition, thus the or

Thanks!!

As I recall you already gotten several answers to your first post regarding
this

=IF(AND(S1="Bank",OR(E1="L",F1="L")),1,0)

or

=(S1="Bank")*((E1="L")+(F1="L"))

Regards,

Peo Sjoblom

"Kim46770" wrote:

I need a formula that will give me results as follows:

If S1=Bank and E1 or F1=L, 1,0

The response to S1 must be Bank, but either E1 or F1 can be L to count as 1.
Both E1 and F1 don't have to meet the condition, thus the or

Thanks!!