How do I calculate maximum with variables.

  • Thread starter Thread starter DanASU
  • Start date Start date
D

DanASU

How do I find the limits given a set of information. IE x is 100-200, y is
50-300 and x+y=275. x generates $50 per unit and y generates $25 per unit.

Thank you,
 
Excel is not needed

Because x generates more money per unit than y, just maximize x.

Therefore x=200
y=75
tota value=11875
 
Thank you for the advice. It seems that this is more complicated than I
originally anticipated, but I think I should be able to get it now.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to I sum different data from different sheets 3
Calculated item - problem 3
Using =RANDBETWEEN(a,b) in a paers of a whole colume 1
INDEX and MATCH with range 3
How to put same scale on X and Y axis on graph 2
Maximum 3
For Next with negative step ? 5
Calculation with IF functions 5

Back
Top