Programming Excel Spreadsheet for Hours Determination

[cgmacias1]

Thanks all for looking at this post. Here is my dilemma:

I'm trying to calculate Work Hours from Total Cost using base Rates.

$ 13,450 = $125(x) + $80 + $145(z)

x = should be between 4 hours and 50 hours
y = should be between 10 hours and 200 hours
z = should be between 10 hours and 200 hours

So if I enter in $ 13,450, the final result should look like this:

$ 13,450 = $125(10) + $80(80) + $145(40)

IS THERE A WAY TO DO THIS IN EXCEL??

 

[shg]

Welcome to the board.

Why that particular solution among many others, e.g.,

= $125(10) + $80(51) + $145(56)

 

[cgmacias1]

Thanks for responding....

Actually the combinations can vary, I just chose these particular numbers because they were at arms length.

As long x, y, and z are whole numbers and not decimals

 

[shg]

You could use Solver.

Enter random values for x, y, and z in A1:C1. In D1,

=SUMPRODUCT(A1:C1, {125,80,145})

Data > Solver, set D1 = Value of: 13450 By Changing Cells: A1:C1, subject to the constraints

A1:C1 = integer
A1 <= 10
A1 >= 4
B1:C1 <= 200
B1:C1 >= 10

 

[cgmacias1]

You're Awesome!!!

I can't thank you enough!!!

 

[shg]

You're welcome, glad it helped.