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

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

Find the maximum and minimum sizes (measured in square footage) of all sample houses.

Solved by X. W. in 14 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 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

Carol will get overtime wages when she works more than eight hours in 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 I. F. in 11 mins