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

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 T. S. in 15 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

I need the formula for: Enter a lookup function in cell E5 that returns the tax deduction amount for the number of dependents listed in the cell C5. Use the table in range H13:I17 to complete the function. The maximum deduction is $500.00; therefore, employees with more than four dependents will
receive no additional deductions.

Solved by D. F. in 20 mins

I'm using data validation to create a dropdown in excel, but there seems to be a maximum number of characters I can use? Any way around that?

Solved by C. J. in 21 mins

Enter a lookup function in cell E5 that returns the tax deduction amount for the number of dependents listed in the cell C5. Use the table in range H13:I17 to complete the function. The maximum deduction is $500.00; therefore, employees with more than four dependents will
receive no additional deductions

Solved by I. C. in 27 mins

I need help in doing my assignment with search function excel VBA solver (search for maximum profit)

Solved by V. Y. in 11 mins