Forum Discussion
How can I use the function O and AND together with IF
1 Reply
There is no definitive answer to such a question as there are endless variations possible.
=IF(OR(A1>10,B1="S"),AND(C1<100,D1<>"M")*1400,IF(AND(E1="H";F1="R"),0.7,5)
How can I use the function O and AND together with IF
There is no definitive answer to such a question as there are endless variations possible.
=IF(OR(A1>10,B1="S"),AND(C1<100,D1<>"M")*1400,IF(AND(E1="H";F1="R"),0.7,5)
