“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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