Question

If the value in A1 is 50, which of the following values will be stored in the current cell when function IF(A1>50, 150,100) is applied?​

Answer 1

Answer:

zero

Explanation:

because the function will store values > 50 and A1=50

Answer 2

When function IF(A1>50, 150,100) is applied, 100 is the value that will be stored in the current cell.

• The value in cell A1 is 50 which will become 100 when the IF function is applied.
• The IF(A1>50, 150,100) function states that if the value, in the cell in which this function is applied, is greater than 50, the value in the cell should be 150.
• For a value less than or equal to 50, the value in the cell should be 100.