Microsoft Office Forums Help to solve this equation.
 Register FAQ Search Today's Posts Mark Forums Read

#1
03-23-2018, 05:01 PM
 Keith2830 Windows 7 64bit Office 2007 Novice Join Date: Mar 2018 Posts: 2
Help to solve this equation.

Attached Images
 Help 01.jpg (293.8 KB, 24 views)
Attached Files
 Help to solve betting.xlsx (13.3 KB, 10 views)
#2
03-24-2018, 11:39 AM
 joeu2004 Windows 7 32bit Office 2007 Novice Join Date: Aug 2016 Posts: 28

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...
#3
03-25-2018, 05:00 AM
 Keith2830 Windows 7 64bit Office 2007 Novice Join Date: Mar 2018 Posts: 2
Thank you!!

Thank you very much joeu2004, i have been trying to solve this for quite some time.
Great explanation as well that really helps.

Cheers mate,

Keith.

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post Belise Leavitt Project 1 02-16-2018 04:32 PM ChrisHoppyBot Office 0 02-20-2013 01:08 AM sid44 Word 1 05-16-2011 09:06 AM Jamal NUMAN Word 2 04-24-2011 06:18 AM middo1022 PowerPoint 0 08-28-2009 04:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:16 AM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top