View Single Post
 
Old 03-24-2018, 11:39 AM
joeu2004 joeu2004 is offline Windows 7 32bit Office 2007
Advanced Beginner
 
Join Date: Aug 2016
Posts: 32
joeu2004 is on a distinguished road
Default

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...
Reply With Quote