I want to use IF function for
=IF(CB3=1 OR BM3>0,Answer1,Answer2).
How to accomplish?
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.