Get instant live expert help on I need help with excel max if
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need a formula to tell me if a product is standard, medium or large if i input length, width and height data worked with the following restrictions
Standard is:
Max dimension <= 52cm, next Max <= 33cm and Min <= 30cm Medium is:
Max dimension <= 120cm, next Max <= 80cm and Min <= 80cm Large is:
Max dimension > 120cm, or next Max > 80cm
Solved by B. L. in 18 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
I need the formula that solves the following nested if for ATP:
If C18 = 0
then C19 = 0
Else If D18 = 0
Then C19=MAX(C18-(C11+C12),0)
Else C19=MAX(C18-(C11),0)
Solved by D. J. in 30 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
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