Get instant live Excel expert help with MAX Function

Hi, I have a table with a cell representing a band of numbers e.g (1-10, 11-20). I want to write a formula in another cell ensuring that the number entered is within the band. i.e number must not be below the minimum value or above the maximum value in the band. Please advise on how i can achieve this. Thanks. Yemi

A dashboard that combines all the data of lets say 3 budgets and dispays it one platform.Budget maximum,minimum,deficits,variances,over expenditure

Create a table of means, standard deviations, and minimum and maximum values below

Hi - I have have a sheet that contains 9 Individual products. We want to create product bundles and with that, also calculate prices for each Bundle. Column A is the product name, Column B is the Individual Price and Column C in the Bundle Price for 3 or more. Row 15 and below are where the Bundle Variations are to appear. We need each row to detail the product names for what is in each bundle and the column next to it to add the price for each bundle. Bundles for 2 are the individual product prices added from Column B, Bundles for 3 or more are from Column C. Individual and Family products will never be bundled together so maximum of 6 products for a bundle. Hoping you can help with the formula!

I have to working formulas and I want to error if either one is not satisfied. Error 1: should be "Use Numbers or Letters Only". Error 2: should be "Maximum of 35 characters only"

The maximum function is not working. It just returns a value of zero. I need help with excel max function!

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?

Hi, I want users of the Excel template i'll build to respect a maximum allowed file size. I need a formula that provides the size of the current excel file. Tks

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.

I have a spreadhseet which relates to volume used. I have a start volume and an end volume with a daily maximum allowance figure which requires random spreading across a fixed period. It needs to be a figure under the daily allowed maximum but not the same figure daily.