Computer Science, asked by simreetg22, 11 days ago

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

Answers

Answered by chiaweishen9
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:

Answered by AllenGPhilip
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}}

Similar questions