Get instant live expert help on min max formula

“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

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
I created this formula in MS Access but it seems it's not working. =[Text413]*[Forms]![Main]![WEIGHT],switch([text413]<[misc min],"20",[text413]>[Max Min],"180") can you please let me know what is it that is wrong with it? The first part of the formula calculate the amount. However the second part of the formula, supposed to return the number to min 20 or max 180.
Solved by K. Q. in 24 mins
Solved by D. S. in 19 mins
help with Max and Min function. Used for calculating revolver credit line draw/paydown
Solved by T. A. in 19 mins