“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

I have a problem regarding to How to Get Information Corresponding to Max Value in Excel

Solved by I. C. in 12 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

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

I need to multiply about 8 rows by an absolute value, but then I need the next 8 to be multiplied by a different absolute value. Is there a way to make this happen automatically?

Solved by S. C. in 30 mins