Get instant live Excel expert help with MAX Function

need help with Part of the data table (B14:H27) has been set up for you. Particularly, C14 links to the initial loan term assumption D9 and cells D14:H14 are set based on the loan term decrement assumption D10; B15 links to the initial annual interest rate assumption B9 and cells B16:B27 are set based on the initial interest increment assumption B10. Please complete the Data Table set up to calculate the monthly payments (as positive numbers) at different interest rates (B15:B27) and loan terms (C14:H14). Note: the data table is designed to be flexible, i.e., it will update automatically for any changes in the loan assumptions A9:D10. Use Conditional Formatting to format C15:H27 such that all the monthly payments that are higher than the maximum allowable monthly payment in N5 are in red color.

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 make a graph of a demand curve for my economics assignment. I was given a raw data consisting only IDs of students and maximum price they would pay for a product. I need help on what kind of functions and graphs I should use to make a demand curve.

i have a spreed sheet with list of prices from different company's. In the header of each column have the company.The first cell of each row gives me the driver and the rest of the row gives me the company prices.The two last columns give me the value of minimum and maximum price for each row. is there a way were i can relate the value in the last two column with company in the header section? for example; the color that i gave to each company be the same in the value in the two last column.

my x axis maximum is too large. how do I change maximums and minimums

I need a formula in Excel to auto filter and provide the best combination of data which gives me the maximum output

I need to sum a range of values, but only the negative values with a maximum total of 60000

I need a formula to determine the sequence in which to do 7 projects in order to minimize the maximum lateness.

vlookup function to get tax deductions amount for the number of dependents listed in cell c5. use the table in h13:h17 to complete the function. The maximum deduction is 500$

Trying to determine which 5 raw products from 5 separate lists are best to use for maximum profit. Non Linear Problem.