IF and OR

[hsandeep]

I want to use IF function for
=IF(CB3=1 OR BM3>0,Answer1,Answer2).
How to accomplish?

 

[Aladin Akyurek]

I want to use IF function for
=IF(CB3=1 OR BM3>0,Answer1,Answer2).
How to accomplish?

Either...

=IF(OR(CB3=1,MM3>0),Answer1,Answer2)

Or...

=IF(OR(CB3=1,N(MM3)>0),Answer1,Answer2)

 

[ps1]

=if(or(cb3=1,bm3>0),"1","2")

 

[hsandeep]

Thanks. But please bear with me little bit more.
I am using formula
=IF(AND(CB3=1,AI3>0),CC3-L3,IF(AI3>0,BM3-L3,IF(BM3<2,0,ROUND(BM3,0))))
In above, at the end, I want IF CB3=1 AND ALSO AI3=0, then only CC3.

 

[Aladin Akyurek]

Thanks. But please bear with me little bit more.
I am using formula
=IF(AND(CB3=1,AI3>0),CC3-L3,IF(AI3>0,BM3-L3,IF(BM3<2,0,ROUND(BM3,0))))
In above, at the end, I want IF CB3=1 AND ALSO AI3=0, then only CC3.

Formulas are not a good device for describing a problem; words are better. Would you explain it in words?