Question

Give the syntax and examples of any three logical function in spreadsheet

Answer 1

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

Explanation:

The three types of logical functions in spreadsheet and their examples are as follows:

• AND: If all conditions are true, the logical AND function returns TRUE and if any condition is false it returns FALSE.

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. FALSE otherwise.

• OR: The logical OR function returns TRUE where one of the terms is TRUE and returns FALSE if every condition is false.

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

Example: =OR(A1>=7, B3<=8)

Description: The formula returns TRUE if A1 surpass or equal to 7 or B3 is smaller or equals eight, or both conditions have been fulfilled. The formula is returned FALSE if none of the conditions are met.

• NOT: The logical NOT function reverses the value that is true to false and false to true.

Syntax: =NOT (condition)

Example: =NOT(A4>15)

Description: The formula returns FALSE if a cell A4 value exceeds 15; otherwise, it returns TRUE.

Learn more:

What are functions in ms excel? explain the different parts of functions...

https://brainly.in/question/6198182

Answer 2

Answer:

Thanks for help I also need this answer