Get instant live expert help on max formula excel
“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
I did a formula ( =MAX(D9,D14,D20,D26,D29)), the max number appears perfectly, but I want the information that appears next to the max number to appear as well. How do I do that? For example , this max formula is also equal to "Instructor Led Training"
Solved by E. H. in 15 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 need you to solve the error in this formula I made. What is the right way to type this formula?
Formula: =IF((AND(MAX(C2:C25),MAX(F2:F25)), "BONUS", " "))
Solved by X. E. in 11 mins
Need help tweaking a COUNTIF formula.. Max number of arguements
Solved by S. C. in 12 mins
Formula for: Max number of days for open ticket (data columns equal number days and a column for status (open, closed). Trying to use Max(if) statement
Solved by A. D. in 26 mins