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 to know the formula to use to find the lowest,average , maxima and minima to find the cost. referancing Column G.
Solved by A. Q. in 23 mins
A supermarket XYZ is determined to please its customers with a customer advantage card. Currently 30% of all shoppers are loyal to XYZ. A loyal customer shops at XYZ 80% of the time. An unloyal customer shops at XYZ 10% of the time. A typical customer spends $150 each week and the profit margin at XYZ is 7.5%. The expected increase of loyal customers is 8% and the percentage of time a loyal customer shops at XYZ is expected to increase by 9%. What is the maximum cost of the advantage card per dollar in order for the program to be profitable?
Solved by O. J. in 26 mins
I need to Apply multiple Validations in a column. 1) Restrict the maximum permissible length of the cells. 2) Restrict few Special Characters How can I achieve this?
Solved by F. F. in 26 mins
For salary ranges: I have the mid and I think I know how to calculate the minimum and maximum. What I don't know how to do is calculate the percentiles, i.e. 25th percentile etc. I looked at the excel examples on line, but I couldn't get them to work.
Solved by G. B. in 20 mins
I need help for one column I have numbers and add always new numbers in again the computer should tell me as soon there are 3 times the same number shows up and only maximum there are 5 numbers show up 2times then if this happen always counting from the last number I added tell me how many counts i have to go upwards to get my start point, and how to find the maximum value of a function in cell A8
Solved by X. F. in 26 mins
counting numbers in one column always count from the last number wait until we have a match a match is maximum 5 numbers with 2 reps and 3 numbers with minima 3reps
Solved by F. W. in 30 mins
I need a formula to multiply 1 cell by 520 and the maximum the product can be is 6000.
Solved by B. U. in 12 mins