225k views
0 votes
In EXCEL, if cell A3 contains the value 50 and B3 contains the value 60, then the calculated result for the EXCEL formula =IF(A3>50,IF(B3<60,1,0),IF(B3>60,1,0)) is ...

1 Answer

3 votes

Final answer:

The calculated result for the EXCEL formula is 0.

Step-by-step explanation:

The calculated result for the EXCEL formula =IF(A3>50,IF(B3<60,1,0),IF(B3>60,1,0)) is 0.

In this formula, the first condition checks if the value in cell A3 is greater than 50. If it is not, the formula will return 0. If it is greater than 50, it checks the second condition, which is checking if the value in cell B3 is less than 60. If this condition is true, the formula will return 1. If it is false, it checks the third condition, which is checking if the value in cell B3 is greater than 60. If this condition is true, the formula will return 1. If both the second and third conditions are false, the formula will return 0.

User Serafin
by
8.3k points