# 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