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

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