Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-23-2018, 05:01 PM
Keith2830 Keith2830 is offline Help to solve this equation. Windows 7 64bit Help to solve this equation. Office 2007
Novice
Help to solve this equation.
 
Join Date: Mar 2018
Posts: 2
Keith2830 is on a distinguished road
Default Help to solve this equation.

Can anyone please help me to solve this?
Attached Images
File Type: jpg Help 01.jpg (293.8 KB, 24 views)
Attached Files
File Type: xlsx Help to solve betting.xlsx (13.3 KB, 10 views)
Reply With Quote
  #2  
Old 03-24-2018, 11:39 AM
joeu2004 joeu2004 is offline Help to solve this equation. Windows 7 32bit Help to solve this equation. 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
  #3  
Old 03-25-2018, 05:00 AM
Keith2830 Keith2830 is offline Help to solve this equation. Windows 7 64bit Help to solve this equation. Office 2007
Novice
Help to solve this equation.
 
Join Date: Mar 2018
Posts: 2
Keith2830 is on a distinguished road
Default 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.
Reply With Quote
Reply

Thread Tools
Display Modes


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
Help to solve this equation. Can anyone solve my problem? sid44 Word 1 05-16-2011 09:06 AM
Help to solve this equation. 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:55 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft