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!”
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
SET FORMLULA TO ALERT MIN 1000 MAX 38000 MULTIPLE OF 100
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