IF FUNCTION

Question 1

This functions performs a comparison between two values.
Evaluates if the supplied comdition satisfies and then returns an output value.

Answer 1

IF FUNCTION

Question 2

Syntax of IF Function

Answer 2

=IF(logical_test, value_if_true, value_if_false)

Question 3

What is the first thing you MUST do when typing an Excel formula?

Answer 3

Always add an = sign

Question 4

The first and mandatory argument of the IF function because it helps us specify the condition to be tested or evaluate as either TRUE or FALSE.

Answer 4

logical_test

Question 5

We need to return as output when “TRUE”.

Answer 5

value_if_true

Question 6

We need to return as output when “FALSE”.

Answer 6

value_if_false

Question 7

Which is the correct formula that represents the IF function with no mistakes.
A. =IF(A1=B2, TRUE FALSE)
B. =IF(A1=B2,”TRUE”,”FALSE”)
C. =IF(A1=B2,TRUE,FALSE)
D. NONE OF THE ABOVE

Answer 7

B.

Question 8

Logical Operators used in IF function

Answer 8

= Equal
< Less than
<= Less than or equal to
> Greater than
>= Greater than or equal to
<> Not equal to