CBSE-IX-Foundation percent 20of%20Information%20Technology%20.
11: MS-Excel 2007
- #5Suggest the appropriate functions for the following situations:
- For returning the minimum value out of a range A1 to C5.
- For determining whether the customer is eligible for discount or not from the bill amount stored in cell D5. A customer is eligible for discount if bill amount >5,000.
Ans :- = MIN(A1 : C5)
- = IF(D5>5,000, “Discount”, “NoDiscount”)
- For returning the minimum value out of a range A1 to C5.