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

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