Question

16. Give the syntax and example of any three logical functions
in spreadsheet.

Answer 1

Answer:

The syntax and examples of any three logical function in spreadsheet is given below.

Explanation:

Syntax: =AND (condition1, [condition2], ...)

Example: =AND(A3>=6, B5<=6)

Description: If the value of cell A3 is greater or equal to 6, and the value of cell B5 is smaller or equal to 6, the formula returns TRUE.