IF+OR+AND formula (Solved)

[RickyT]

I am sure this won't be difficult for any of you, but I need answer to this, please.

 

[ETAF]

=IF(OR(AND( A3="BUY", C3>=10),AND(A3="sell",B3>=10)),1,0)

 

[RickyT]

Thank you so much. I used to be more adept at vExcel, but that was some 15 years ago.

 

[ETAF]

you are welcome

 

[RickyT]

Thank you again. I was going crazy. I just could not wrap my head around it.

 

[pecoflyer]

A more descriptive thread title in the future perhaps?

 

[RickyT]

A more descriptive thread title in the future perhaps?

Thank you. Yes, good idea.