Question

Price of two goods X and Y are Rs 5 and Rs 6 and their utilities are 40 and 60 utils respectively.The consumer will consume

more units of X and less units of Y

less units of X and more units of Y

more units of both X and Y

none of these

​

Answer 1

Explanation:

To return "Pass" when any 4 subjects have a passing score, and "Fail" when not, you can use a formula based on the IF and COUNTIF functions. In the example shown, the formula in I5 is:

=IF(COUNTIF(C5:H5,">=70")>=4,"Pass","Fail")

where 70 represents the passing score for all subjects.

Explanation

Working fron the inside out, this formula uses the COUNTIF function to count passing scores in all six subjects:

COUNTIF(C5:H5,">=70") // count passing subjects

The result in I5 is 3, in I6 is 5, and in I7 is 6. It's a good idea to use COUNTIF alone as you start this formula, to make sure you are getting the results you expect before adding more logic.