H4: =(10 - D3) / SUMPRODUCT(1/F4:F8)
H5: =$H$4
Copy H5 into H6:H8
Algebraic derivation....
D4 = H4/F4
D5 = H5/F5 = H4/F5 (because H5 = H4, by requirement)
D6 = H4/F6
D7 = H4/F7
D8 = H4/F8
D3 + D4 +...+ D8 = 10 (by requirement)
D4 +...+ D8 = 10 - D3
H4/F4 +...+ H4/F8 = 10 - D3
H4 * (1/F4 +...+ 1/F8) = 10 - D3
H4 = (10 - D3) / (1/F4 +...+ 1/F8)
Last edited by joeu2004; 03-24-2018 at 03:36 PM.
Reason: minor; correct typo in D4+...+D8 = 10...
|