Get instant live expert help on max value calculator

“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

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
Data in column A = AE0001 AE0002 AE0003 AE0004 AE1001 AE1002 AE1003 AE2001 AE2002 AE2003 AE3001 AE3002 AE3003 AE4001 AE4002 i want to type a formula that can return automatically look for data that starts with AE0 and return me the max value i.e. AE0004 and look for AE1 and return me tha max value i.e. AE1003 and look for AE2 and return me tha max value i.e. AE2003 and look for AE3 and return me tha max value i.e. AE3003 and look for AE4 and return me tha max value i.e. AE4002.
Solved by C. C. in 26 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
Hi, Looking for a formula. I have a set of data and want to add in one cell that has the max value and have another cell display which Name that max value is associated with
Solved by O. E. in 28 mins
I need a formula for 5 cells, each to have a max percentage of 100, for max value calculator which max value is 100 also.
Solved by I. S. in 14 mins