Get instant live Excel expert help to learn how to find max and min in Excel?

i have theree cols.. sales,category date.. I want the month of maximum sales in each category

I need a formula to define the following values of conditional format, and scale of 3 colors. Minimum: 0 to 69 Middle Point: 70 to 89 Maximum: 90 to 100

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.

I have an excel spread sheet where the "Pressure" cell and the material alloy are drop down menu cells. In another tab, I have the Hose Part Number one column, the diameter row is across the top, in the cell where the Part number and diameter intersect is a pressure rating. User, selects the Pressure and the alloy, I want to return the Hose Part number that falls above the press. rating that was inserted. For Example: Press. - 250 PSI Alloy - T321 Part Number: The hose has a maximum press. rating, so I would need it to select the part number of the hose that is the closest highest pressure. Can this be done?

What is the maximum cost of the advantage card per dollar in order for the program to be profitable?

Enter a lookup function in cell E5 that returns the tax deduction amount for the number of dependents listed in 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.

i H AVE A SPREADSHEET AND i NEED TO A FORMULA TO FIGURE OUT THE HIGHEST PRICE AND LOWEST PRICE PAID FOR FOOD ITEMS. I'VE FIGURED THE MINIMUM PRICE AND MAXIMUM PRICE, BUT I NEED THE DATE TO CORRESPOND WITH THE PRICE. I CAN'T FIGURE OUT THE FORMULA TO DO THAT

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?

Insert a Scroll Bar (Form Control) onto the Break-Even Analysis worksheet within the range E4:E17. Modify the Format Control properties based on the following: Current value: 64 Minimum value: 60 Maximum value: 100 Incremental change: 1 Page change: 10 Cell link: D4

I have temperature data in an excel sheet for each of 12 months, with minimum and maximums. Some temperatures are minus degrees C some aren't. Why can't Excel create a line graph of that?