Question

Give the syntax and example of any three decision making functions in spreadsheet?​

Answer 1

The syntax and example of any three decision making functions in spreadsheet are as follows:

• Basic Operators: These functions help us to determine if a condition is true or false.The syntax has three parts - Excel cell address, Conditional operator, Value. There are multiple operators: =, >, < etc.

Example: If we testing if A2(=650), is greater than 600 or not, the syntax would be: =A2>600.

• If-Then: It also has three parts - Condition, Activity in case of condition returns true, Activity in case of condition returns false. Example: the syntax would be: =IF(condition,showwhentrue,showwhenfalse).

• Logical Operators: These include AND and OR. It will return a value TRUE or FALSE.

Example: Among three scores, to test if all scores are at least 600, the syntax would be:

=AND(A2>=600,B2>=600,C2>=600), provided A=600, B=610, C=630.

Answer 2

Explanation:

Basic Operators: These functions help us to determine if a condition is true or false. The syntax has three parts - Excel cell address, Conditional operator, Value. There are multiple operators: =, >, < etc. Example: If we testing if A2(=650), is greater than 600 or not, the syntax would be: =A2>600.