write the syntax of (IF) in the logical functions of spreadsheet
Answers
Answered by
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
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")
Similar questions
Computer Science,
10 days ago
Math,
11 days ago
Math,
11 days ago
English,
9 months ago
Business Studies,
9 months ago