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 need the value displayed to be no less than 0; if between 0 and 3 then display 0; if 6 or more then just display 6. So far I have come up with =(MAX(0;(MIN(6;($D27-2)+1)))) but this is still displaying values of 1 and 2
Solved by X. F. in 20 mins
I know I am doing something wrong but I need help fixing it, I need to get the min and the max from a pivot table and get the difference and find the maximum rate of change calculator
Solved by F. F. in 16 mins
Hi I have a column which gives me daily temperatures since 1975 till 2017. I am trying to calculate the cumulative deviation of temperature and trigger a payout if the cumulative is greater than 150 degrees celcius or 250 degrees. The deviation is based on 'triggers' so if the daily max temp is 30 and the trigger is 31 then the cumulative deviation is -1 and so on. I have a set of 6 triggers - 31, 33 35.5 38 39.5 and 39. How can I calculate this on excel?
Solved by O. C. in 13 mins
How to a calculate the following with a formula in a simulation: I have to randomly select 18% of 100 customers that use a 7% coupons with a "Yes" or "No" as the result. Information: I have 100 customers who purchase grocery from min $5 to max $250.
Solved by V. L. in 12 mins
I need a formula that returns values from min to max, from an array of 3 values. If there are repeats with those 3 values, it must return zero. i.e. column 1 is always the minimum column 2 is greater than column 1 or zero Column 3 is greatest value or zero there are not always 3 values in the array, in some cases value appear more than once in the array.
Solved by A. Y. in 23 mins
Hi i have 2 sheets that both have an "id" column and next to one of them is a column that says the manager for the id i want to like if they max it moves over the current manager to the right id on the first sheet its like 1617 id and names and i want to sort them with their right manager.
Solved by M. Q. in 13 mins
Hello, how to find max and min of a function? Also, I need help with problem in max indirect
Solved by V. F. in 21 mins
I have a formula that basically measures efficiency of an experiment ( so we get a value that should range anywhere from 50-100, however the procedure isn't quite accurate yet so we have values that are greater than 100) In order to use these values in our data calculations still we need to make everything that is over 100 just equal 100, instead of going through and hand changing everyone of them, is there a function in excel that I could use instead like maybe a max value or something?
Solved by I. D. in 13 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
Need help tweaking a COUNTIF formula.. Max number of arguements
Solved by S. C. in 12 mins