Question

write the syntax of (IF) in the logical functions of spreadsheet​

Answer 1

Answer:

Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it's false. For example: =IF(A2>B2,"Over Budget","OK") =IF(A2=B2,B4-A4,"")

Explanation:

Answer 2

If is a logical function, this function is used to evaluate a condition. If the condition is true true part will be evaluated else false part will be evaluated

Syntax:-

=IF(logical_test,[value is true],[value is false])

Example:-

A1 = 18

In cell B1 type the formula

First type = sign

Then type IF

Then select the cell A1

=IF(A1>=18,"QUALIFIES FOR DRIVING","NOT QUALIFY FOR DRIVING")

$\boxed{\bf{Out put:- QUALIFIES\: FOR \:DRIVING}}$