|
|
#2
03-24-2018, 11:39 AM
|
|||
|
|||
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... 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help solve this problem. | Belise Leavitt | Project | 1 | 02-16-2018 04:32 PM |
| Can anyone solve this problem? | ChrisHoppyBot | Office | 0 | 02-20-2013 01:08 AM |
 Can anyone solve my problem?
|
sid44 | Word | 1 | 05-16-2011 09:06 AM |
|
Why copying a paragraph to an equation ends without equation format???
|
Jamal NUMAN | Word | 2 | 04-24-2011 06:18 AM |
| please help me to solve this issue...... | middo1022 | PowerPoint | 0 | 08-28-2009 04:47 AM |
Windows 7 32bit 
Office 2007
Threaded Mode