AND
|
Form
|
Where
|
Result
|
|---|---|---|
|
AND(a, b)
|
a is logical
b is logical |
A logical value, true or false
|
Description
Gives true only if both a and b are true. Otherwise gives false.
|
Example
|
Result
|
|---|---|
|
=AND(4 > 3, 5 < 7)
|
True
|
|
=AND(4 > 3, 5 < 4)
|
False
|
OR
|
Form
|
Where
|
Result
|
|---|---|---|
|
OR(a, b)
|
a is logical
b is logical |
A logical value, true or false.
|
Description
Gives true is either a or b (or both) is true. Otherwise gives false.
|
Example
|
Result
|
|---|---|
|
=OR(4 > 3, 5 < 7)
|
True
|
|
=OR(4 > 3, 5 < 4)
|
True
|
|
=OR(3 > 4, 5 < 4)
|
False
|
NOT
|
Form
|
Where
|
Result
|
|---|---|---|
|
NOT(a)
|
a is logical
|
A logical value, true or false
|
Description
True if a is false, or false if a is true.
|
Example
|
Result
|
|---|---|
|
=NOT(4 > 3)
|
True
|
|
=NOT(NOT(1 = 1)
|
True
|
TRUE
|
Form
|
Result
|
|---|---|
|
TRUE()
|
A logical value, always true
|
Description
Gives you a logical true.
|
Example
|
Result
|
|---|---|
|
=TRUE()
|
True
|
FALSE
|
Form
|
Result
|
|---|---|
|
FALSE()
|
A logical value, always false
|
Description
Gives you a logical false.
|
Example
|
Result
|
|---|---|
|
=FALSE()
|
False
|
IF
|
Form
|
Where
|
Result
|
|---|---|---|
|
IF(c, v, w)
|
c is logical
v is anything w is anything |
Either v or w
|
Description
Gives v if c is true, or w if c is false. Both v and w must be the same kind of value - both numbers or both text.
|
Example
|
Result
|
|---|---|
|
="Hello" & IF(Gender = "Male", "sir", "madam")
|
Gender = Male
"Hello sir" Gender = NOT Male "Hello madam" |