Question

When working in excel online, which of the following is considered a conditional formula?

A) A1+F1-H1
B) If(A1>1,true,false)
C) =sum(A1:J1)
D) =sum(A1:A9)-A10

Answer 1

If(A1>1,true,false)

Step-by-step explanation:

A conditional formula always contains keyword "if". The output value is dependent on whether the condition defined in the if statement is met or not.

In the given statement If(A1>1,true,false), the Excel will check if A1 bigger than 1, it will result in true value otherwise false value. This is consider a simple example of conditional formula that only handles two conditions. In some complex cases that need to handle more than two conditions, we have to extend the formula with additional if statement.

Answer 2

B. Because conditional statements have an IF before stating the condition