Reference Guide for Logical Functions AND IF OR

REFERENCE GUIDE FOR LOGICAL FUNCTIONS AND IF OR

AND

- Checks if all of the conditions are satisfies or not

=AND(first condition, [additional conditions], ...)

=AND(MONTH("12/12/18")=1,500 > 1000) = FALSE

IF

- It returns a value that you set if a condition is met, and a value if it is not met

=IF(condition to be checked, Value if the condition is met, Value if condition is not met)

=IF(D15>300,"Bonus","No Bonus") = No Bonus

OR

- Checks if any one of the conditions is satisfied or not

=OR (MONTH("12/12/18")=1, 1500>1000) = TRUE