Get instant live Excel expert help with MAX Function

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

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: & " + -

need to plot neighbourhood for matrix in my excel sheet with nearest value max 1 min 0

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...

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

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?

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.

how to use excel max if function? I get a value error for my If Function =IF(MAX(B2:M2<10),"E","")

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

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)