Get instant live Excel expert help with MAX Function

i need to know the formula to use to find the lowest,average , maxima and minima to find the cost. referancing Column G.

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?

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?

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.

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

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

I need a formula to multiply 1 cell by 520 and the maximum the product can be is 6000.