Ask Question
18 December, 03:07

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

+3
Answers (2)
  1. 18 December, 03:08
    0
    If (A1>1, true, false)

    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.
  2. 18 December, 03:31
    0
    B. Because conditional statements have an IF before stating the condition
Know the Answer?
Not Sure About the Answer?
Find an answer to your 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 ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers