| =AND() | =NOT() | =OR() |
| =IF() | =IFS() | =IFERROR() |
=AND()
This function combine multiple conditions if all conditions are true then it returns true when one of the condition is false it returns false
Truth Table
| A | B | =AND(A,B) |
|---|---|---|
| T | T | True |
| T | F | False |
| F | T | False |
| F | F | False |
Syntax: =AND(condition1, condition2.....)
Ex- =AND(60>50, 50=53) Output: False
=OR()
In this case if any one of the condition is true then it returns true if all the conditions are false it returns false.
Truth Table
| A | B | =OR(A,B) |
|---|---|---|
| T | T | True |
| T | F | True |
| F | T | True |
| F | F | False |
Syntax: =OR(condition1, condition2.....)
Ex- =OR(60>50, 50=53) Output: True
=NOT()
In this case if the condition is true then it returns false and if the condition is false it returns true.
| Condition | =NOT(condition) |
|---|---|
| T | False |
| F | True |
Syntax: =NOT(condition)
Ex- =NOT(60 > 50) Output: False
=IF()
This function returns the result based one certain conditions.
Syntax: =IF(logical_test, value if true, value if false)
Ex: If any number is less than 40 add 10 marks extra
=IFS()
This function evaluates one or more conditions and returns a value upon evaluating a true condition.
Syntax: =IFS(logical test1, value if true1, ......)
Ex:If time more than 40 - Overtime Pay, if time equal to 40 - Good Work, If time less than 40 - Work hard
=IFERROR()
This function shows the result if the given condition is false or not working
Syntax: =IFERROR(value, value_if_error)
Ex: If result is error show not divided by 0
