Hi
Please kindly see attached picture.
I want a formula that make the final value in Red text = 7, What is the value shoud be for yellow color cell?
thanks a lot.
Hi
Please kindly see attached picture.
I want a formula that make the final value in Red text = 7, What is the value shoud be for yellow color cell?
thanks a lot.
Paste in F2:
Please Login or Register to view this content.
Note: I am using the posters column headers of A,B,C,G etc. etc. and not the EXCEL columns.
If I understand you correctly, you are not needing a formula - you just need a value provided for an existing formula where the result will be 7
(J14+G14)/H14 = 7
(J14+(A14-B14-C14)/H14 = 7
(3700+1180-650-C14)/253.33 = 7
MULTIPLE BOTH SIDES BY 253.33
(3700+1180-650-C14) = 1773.31
(4230-C14)= 1773.31
SUBTRACT 4230 FROM BOTH SIDES
(-C14) = -2456.69
MULTIPLE BOTH SIDES BY -1
(C14) = 2456.69
PROOF
(J14+G14)/H14 = X
(J14+(A14-B14-C14)/H14 = X
(3700+(1180-650-2456.69)/253.33 = X
(1773.31)/253.33 = X
(7) = X
And if I misunderstood your need, I apologize
So, 2456.69 is the value you seek
Last edited by svance; 10-06-2019 at 10:24 PM. Reason: CLARIFICATION
(J14+G14)/H14 =7
=> (J14+G14)=H14*7
=> G14=H14*7-J14
=> C14=-H14*7+J14+A14-B14
Formula in C14: -H14*7+J14+A14-B14
Last edited by Phuocam; 10-06-2019 at 10:29 PM.
thanks a lot. it works
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks