Get instant live Excel expert help with MAX Function

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I want to work out average in excel, max and min for each month over time. I have 5 years worth of data. Please help!!!
Solved by G. A. in 20 mins
I am trying to place a band into a chart, the min is 4 and the max is 10. when the band appears on the graph the min is 4 and the max 14? why cant i have the band reflect the 10 that i need to be represented in the graph
Solved by S. A. in 19 mins
Hello, i have a column with several numbers. In a second column, i want the total of the first column, but only until the biggest number in the first column. Imagine, the numbers are from B1:B8. In the second column, i wanted to use "=Sum(B2:Max(B2:B8))"...but it doesnt work. Can you help me
Solved by G. H. in 16 mins
I need a formulas using only this functions , Mod IF and or round roundup sqrt min max sin cos to figure out how many hrs does a take to do a job Example. 10 to 20k 30 hrs 20001 to 30 k 60 hrs and so on increments of 10 k increments of 30 hrs
Solved by D. H. in 30 mins
Column C contains numbers only from rows 9 to 21. These could be either whole numbers - 1, 2, 3 etc or decimal numbers 3.5, 4.2 or 5.0. Minimum is 1 max is 5. If a cell C9 - C21 does not have a number then Cell H21 to insert 'ERROR' and conditional format cell to warning colour - red.
Solved by A. J. in 23 mins
I got the following formula in my latest session: =_xlfn.MAXIFS(Q:Q;C:C;C2) But Excel 2016 does not have the maxifs function anymore, I need some help with changing to MAX(IF(
Solved by G. A. in 23 mins
I am trying to set up a spreed sheet in excel to automate cutting lits generation . but i can not work out how to find, a formula to return how many results i have between set figures. I.e. if the min is 1000mm and max is 1500mm how can i find out all numbers between them ?
Solved by V. D. in 29 mins
I need a formula to nest letter grades based on a grading system of percentages with A being above 90% of the max score of 80, B above 80%, C above 70%, and an F below 70%
Solved by A. E. in 25 mins
I have two separate MAX formulas in cells M19/M20.# i wish to have both formulas in a MAX fuction in M19.
Solved by C. S. in 24 mins
I need help with a formula. Data: Extra person charge : 800 Max of 4 people in 1 room Only have extra charge if there is a 3rd and/or 4th person in the room Eg. 1 room, 3 adults = 800 extra person charge 2 rooms, 5 adults = 800 extra person charge 2 rooms, 7 adults = 2400 extra person charge I need help with making a formula to satisfy all the requirements so Ill be able to monitor the total income from each booking
Solved by M. C. in 15 mins