Get instant live Excel expert help to learn how to find max and min in Excel?
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Linear Programming Problem
The problem is a cost minimisation problem, about producing LCD TVs, which manufacturers to produce with, and which channels to distribute it through. Question 1 Answer sheet is the main one with the objective function, the decision variables, and the constraints.
I am primarily having trouble with the constraints, the final 3 shown on the 'DHL' sheet to be exact, which are about the minimum number of a certain type of TV to be produced by any one of the manufacturers but a minimum number that has to be sent through certain channels. I have a basic constraint already that outlines it but I feel it is inadequate
Solved by Z. H. in 14 mins
Linear Programming Problem The problem is a cost minimisation problem, about producing LCD TVs, which manufacturers to produce with, and which channels to distribute it through. Question 1 Answer sheet is the main one with the objective function, the decision variables, and the constraints. I am primarily having trouble with the constraints, the final 3 shown on the 'DHL' sheet to be exact, which are about the minimum number of a certain type of TV to be produced by any one of the manufacturers but a minimum number that has to be sent through certain channels. I have a basic constraint already that outlines it but I feel it is inadequate
Solved by F. J. in 11 mins
Trying to input a Name if that person is marked 'Y' for clock in, and is the minimum for a certain value. Cannot figure out a formula to do this.
Solved by C. H. in 24 mins
Sales, general, and administrative cost is charged at 40% of the total manufactured cost. What is the total cost of the product?
All products are required to sell at a minimum profit of 20%. What is the minimum selling price? Profit percentage is (Selling price - Full product cost)/Selling price.
Solved by B. Y. in 14 mins
I need a column E (first investment date of the firm into 1 company) that calculates the minimum of column D (investment dates). A firm (column A) invests in a company (column C), however, multiple firms can invest in one company. Thank you in advance for the help!
Solved by D. F. in 26 mins
How do I start tick marks on a specific value on the x-axis in Excel? I want the graph to show a minimum of 190 on the x-axis BUT I want the tick marks to start counting from 200 in increments of 100
Solved by K. U. in 21 mins
I need to combine two formulas for pricing sheet, the minimum cost can not be lower than $120
Solved by F. W. in 21 mins
I have an assignment which needs me to use Excel to find Standard Error and Confidence Level of 99% for the top 20 areas when kth largest and kth minimum are both equal to 1.
Solved by E. B. in 21 mins
Can anyone explain to me the maximum and minimum values of a function?
Solved by G. L. in 18 mins
Hi, please explain to me about the excel small function.
Solved by V. E. in 14 mins