Get instant live Excel expert help with MAX 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

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
Assume that the contents of every cell in Column A from A2 down are in the form: First Middle Last Assume there are no hyphenated or abbreviated names. All names in Column A are exactly three single words. You want the contents of every cell in Column B from B2 down to be of the form: FML What are the minimum number of function calls necessary to acheive such a formula? A "function" is one that is usually capitalized and always has parentheses. For example, IF() is a function. So is SUM() and MAX(). Assume you can use as many of the following you want, which do not count against the total since they do not require parentheses: & " + -
Solved by I. H. in 30 mins
need to plot neighbourhood for matrix in my excel sheet with nearest value max 1 min 0
Solved by G. Q. in 17 mins
I need a formula to calculate the maximum rows in excel as a range of 167 rows in column D, then find the MAX of the next 167 rows in column D and so on continuously through the entire sheet. Example MAX D2:D169, D170:D337, D338:D505 etc...
Solved by I. Q. in 29 mins
As of now I have a formula that shows the MAX for a range of 167 rows continuously for an entire sheet. Example: D1:D169, D170:D337 etc...Each row of data also contains a Date and Time and I would like to show the date and time that the MAX occured
Solved by E. H. in 21 mins
I need a formula, Cells E6 to E33 have numbers and letter, example "53.0 benchmark" or "53.0 H4831". Now in cells O6 to O33 have "Max is 52.5" The question is, I would like the cell in lets say E7 to change colour if the NUMBER only in O7 is less than the number in E7?
Solved by A. L. in 17 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
how to use excel max if function? I get a value error for my If Function =IF(MAX(B2:M2<10),"E","")
Solved by G. H. in 11 mins
I need a formula to calculate CPP deductions monthly. The formula I have =IF((J7-$C$109/12)*$C$112*9<=$C$110,MAX((J7-$C$109/12)*$C$112,0),MAX($C$110-(J7-$C$109/12)*$C$112*(9-1),0)) is not working correctly. J7 = annual salary C109 = Base Exemption of 3,500 C122 = Rate of 4.95% C110 = Max CPP contribution of 2593.90
Solved by K. S. in 25 mins
In Open Off. Calc I need a formula that finds the max value in a row of cells and then divides that max value by 6, IF the max value is in column D, and divides by 4 IF that max value is in column E, and divides by 2.4 IF that max value is in column F, etc. I tried =if(max(d3:i3)=d3)/6 and that worked fine to give me the correct fraction as a result (0.167) when the max value in the row was in d3 with a value in d3 of 1.00, but when I tried it with a value of 2.00 in the next row (d4) I got the same result of 0.167 when it should be 0.333. Then, when I tried =if(max(d3;i3)=d3)/6, if(max(d3:i3)=e3)/4 I got an Error 509. (formulas in column M)
Solved by C. J. in 29 mins