20.1k views
5 votes
Given that cells A1, A2, and A3 contain values 2, 3, and 10, respectively, and B6, C6, and D6 contain values 10, 20, and 30, respectively, what value will be returned by the function =IF(B6>A3,C6A1,D6A2)?

a) 60
b) 100
c) 200
d) 300

User Dzinx
by
8.3k points

1 Answer

3 votes

Final answer:

Using the IF function with the values provided, since B6 is not greater than A3, the result is D6 multiplied by A2, which is 30*3, equal to 90. Thus, none of the provided options (a, b, c, d) is correct.

Step-by-step explanation:

The student has asked for the result of the Excel function =IF(B6>A3,C6A1,D6A2). With the given values that cells A1, A2, and A3 contain 2, 3, and 10 respectively, and B6, C6, and D6 contain 10, 20, and 30 respectively, we need to check if the content of cell B6 is greater than that of A3. Since both B6 and A3 contain the value 10, the condition B6 > A3 is false. Therefore, the function will return the value of D6A2, which is 30 multiplied by 3, resulting in 90. However, since 90 is not one of the options provided in the multiple-choice answers, and presuming there may have been an error in the student's question, the correct answer is none of the options provided.

User Teysz
by
8.4k points