OR function
Summary
Returns TRUE if any argument is TRUE
Syntax
OR(logical1, [logical2], ...)
Example
=OR(A2>1,A2<100)
=IF(OR(A2>1,A2<100),A3,"The value is out of range")
=IF(OR(A2<0,A2>50),A2,"The value is out of range")
=IF(OR(B14>=$B$4,C14>=$B$5),B14*$B$6,0) - IF Total Sales are greater than or equal to (>=) the Sales Goal, OR Accounts are greater than or equal to (>=) the Account Goal, then multiply Total Sales by the Commission %, otherwise return 0.
=IF(OR(A2>1,A2<100),A3,"The value is out of range")
=IF(OR(A2<0,A2>50),A2,"The value is out of range")
=IF(OR(B14>=$B$4,C14>=$B$5),B14*$B$6,0) - IF Total Sales are greater than or equal to (>=) the Sales Goal, OR Accounts are greater than or equal to (>=) the Account Goal, then multiply Total Sales by the Commission %, otherwise return 0.