“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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