AND function
Summary
Returns TRUE if all of its arguments are TRUE
Syntax
AND(logical1, [logical2], ...)
Example
=AND(A2>1,A2<100)
=IF(AND(A2<A3,A2<100),A2,"The value is out of range")
=IF(AND(A3>1,A3<100),A3,"The value is out of range")
=IF(AND(B14>=$B$7,C14>=$B$5),B14*$B$8,0) – IF Total Sales are greater than or equal (>=) to the Sales Goal, AND Accounts are greater than or equal to (>=) the Account Goal, then multiply Total Sales by the Bonus %, otherwise return 0.
=IF(AND(A2<A3,A2<100),A2,"The value is out of range")
=IF(AND(A3>1,A3<100),A3,"The value is out of range")
=IF(AND(B14>=$B$7,C14>=$B$5),B14*$B$8,0) – IF Total Sales are greater than or equal (>=) to the Sales Goal, AND Accounts are greater than or equal to (>=) the Account Goal, then multiply Total Sales by the Bonus %, otherwise return 0.