Get instant live expert help on max and min of a function

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

help with Max and Min function. Used for calculating revolver credit line draw/paydown
Solved by T. A. in 19 mins
I need a formula or function to calculate the average of a series of cells but filtering out the top(MAX) and bottom(MIN) cell quantities
Solved by K. U. in 16 mins
MAX MIN formula for revolving line of credit
Solved by K. Y. in 24 mins
I need a formula to tell me if a product is standard, medium or large if i input length, width and height data worked with the following restrictions Standard is: Max dimension <= 52cm, next Max <= 33cm and Min <= 30cm Medium is: Max dimension <= 120cm, next Max <= 80cm and Min <= 80cm Large is: Max dimension > 120cm, or next Max > 80cm
Solved by B. L. in 18 mins
Looking for a way to get a MIN result across a row of numbers but after a randomly chosen spot. Ex. Row 1 ( Commas are separate cells ) 455,2,223,5667,32323,56,3,2323,34 I have used the MAX function to locate the MAX value in Row 1 EX - 32323 I need to Return a MIN result after that MAX number position. EX - 3 The MAX will be in random spots every time I input data into a new sheet.
Solved by M. U. in 30 mins