CBSE-IX-Foundation percent 2520of%2520Information%2520Technology%2520.
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.