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
Need an "If", "And", "Then" formula. In the attached chart: A1 is a minimum charge, A2 is a piece charge. C3, D3, E3 and F3 represent differing quantities. C4, D4, E4 and F4 are calculated to show the amortized cost of each quantity using the "A1" minimum charge. I need a formula in what would be cells C5 thru F5 that displays the value in "A2" when the values in C4 thru F4 are less than the values in "A2"
Solved by F. L. in 23 mins
Q1. Using Solver, maxmize the profits but subjected to the following constraints
a. Total capacity is limited to 29000
b. A minimum of 2750 units of P1 have to be produced to meet government manadated requirements
c. A mimimum of 1800 units of P2 has to be produced to meet loyal customer requirements
d. click on solve and then save the solution as a scenario as well and call it "best possible scenario"
e. On your solver, after you have clicked on save the scenario in step d, click on "restore original value" and then save the workbook
Solved by O. A. in 11 mins
This problem uses Solver from Excel.
Q1. Using Solver, maxmize the profits but subjected to the following constraints
a. Total capacity is limited to 29000
b. A minimum of 2750 units of P1 have to be produced to meet government manadated requirements
c. A mimimum of 1800 units of P2 has to be produced to meet loyal customer requirements
d. click on solve and then save the solution as a scenario as well and call it "best possible scenario"
e. On your solver, after you have clicked on save the scenario in step d, click on "restore original value" and then save the workbook
Solved by I. F. in 30 mins
trying to make a minimum value of a function equal to a name of a supplier
Solved by X. Y. in 20 mins
search a column which has multiples of the same value and return the minimum value of another column in the array
Solved by I. J. in 26 mins
Hello, I am hoping y'all can help me, I am attempting to create a worksheet which will auto sum my incoming inventory and display an appropriate PO value once the minimum quantity is received for an order.
Solved by I. E. in 25 mins
Hey please help me out what is the time where supply is at its minimum in a 36hour period
Solved by X. W. in 27 mins
Hey please help me out what is the time when supply is at its minimum in a 36hour period
Solved by T. Y. in 26 mins
Hey, I am having issues trying to calculate the time when supply is at its minimum in a 36hour period
Solved by B. Y. in 24 mins
I am having issues trying to calculate the time when supply is at its minimum in a 36hour period. Could you please help me?
Solved by Z. S. in 23 mins