Get instant live expert help on how to find the minimum value of a function
“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
Luke will get overtime wages when he works more than eight hours a day. Calculate the non-overtime hours in cell H6 by using the MIN function to return the minimum of the value in cell G6 and the value 8.
Solved by E. F. in 12 mins
I need help with the ADDRESS function to help me average a range based on the minimum value for columns B to Q. For example, for Column B the lowest value is cell B161. I need a dynamic formula to do this =AVERAGE(B159:B163). Basically, 5 cells. 2 cells above and below and the minimum value. Thanks!
Solved by A. F. in 18 mins
How to use FIND function to locate the position of a character
Solved by G. W. in 25 mins
I need to use an IF formula that can find the minimum value from column "B" and then enter the name given in column "A" from the same row
Solved by B. D. in 17 mins
I have a series of functions that involve averaging the values surrounding the minimum value of an array, and for each array the point in the array where the minimum can vary. Is there a function or combination of functions that will allow me to (for example) average(location(min(array)+2):location(min(array)-2))? A method to read out variable cell locations?
Solved by B. B. in 13 mins