How to use MAX and MIN formula in excel?
Formula: =MAX(range) Description: The MAX function returns the largest value in a range of cells. Example: =MAX(A1:A10) This formula will return the largest value in cells A1 to A10. Formula: =MIN(range) Description: The MIN function returns the smallest value in a range of cells. Example: =MIN(A1:A10) This formula will return the smallest value in cells…