Add two combinations of numbers with Excel formula

[kelly mort]

In A1 I will input number of items say 30 or whatever.

Then A2 will contain target price

Inside A4 I have a unit price of items.
Then A5 contains a different unit price for same items.

Now I want a way to add different combinations of the two unit prices to give me my target price.

And I want those numbers appear in B4 and B5 respectively.

I need formulas for that.

Hope someone can fix that for me.

Thanks

 

[mikerickson]

So you want a solution to the system of equations

B4 + B5 = A1
and
A4*B4 + A5*B5 = A2

B4 = A1-B5

A4*(A1-B5)+A5*B5 = A2

(A5-A4)*B5 = A2 - A4*A1

B5 = (A2-A4*A1)/(A5-A4)
B4 = A1-B5

unless, I've made an error in algebra.

 

[kelly mort]

So you want a solution to the system of equations

B4 + B5 = A1
and
A4*B4 + A5*B5 = A2

B4 = A1-B5

A4*(A1-B5)+A5*B5 = A2

(A5-A4)*B5 = A2 - A4*A1

B5 = (A2-A4*A1)/(A5-A4)
B4 = A1-B5

unless, I've made an error in algebra.

Yeah. I wanna know if it is possible .

And sorry for late reply. My network went down.

 

[Rick Rothstein]

Yeah. I wanna know if it is possible .

Mike gave you the answer in his post...

So you want a solution to the system of equations

B4 + B5 = A1
and
A4*B4 + A5*B5 = A2

B4 = A1-B5

A4*(A1-B5)+A5*B5 = A2

(A5-A4)*B5 = A2 - A4*A1

B5 = (A2-A4*A1)/(A5-A4)
B4 = A1-B5

The red part is the two equation to solve and the blue part is the line-by-line algebraic manipulations to produce the last two lines which are your solution.