Zoho Sheet

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

FUNCTION

DESCRIPTION

ARGUMENTS

ARGUMENT DATA TYPE

RETURN TYPE

USAGE

EXAMPLE

Numeric Functions

Returns one of two values, depending on the
value of a given logical condition. If the boolean
test is true, If() returns the true value,
otherwise returns the false value.

Boolean,Generic,Generic

Generic

If(Boolean,Generic,
Generic)*

If(8>7,1,0) returns "1.0"
If(8>7,'True','False') returns "True"

And

Returns a true response if all expressions
are true; returns a false value even if one
of the expressions is false.

Multiple

All Boolean

Boolean

And(boolean,boolean ...)

And(2>1,5>3,7<8) returns "True"
And(2>1,5>3,7>8) returns "False"

Returns true if any one expression is true.
Returns false if all expressions are false.

Multiple

All Boolean

Boolean

Or(boolean,...)

Or(2>1,3>5,7>8) returns "True"
Or(1>2,3>5,7>8) returns "False"

Not

Returns the logical negation of the given
expression (If the expression is true,
returns false).

Boolean

Not(boolean)

Not(false) returns "True"
Not(true) returns "False"

* Generic implies any data type - Number, String, Datetime (including normal date) or Boolean. The return type depends on the selected data type.
For instance, if the generic data type is a number, the return type should be Numeric and not string or boolean.

Numeric

String

DateTime

Boolean