Formula problem

K

Keith2830

New Member
Joined
Mar 14, 2018
Messages
3
<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-GB</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:DontVertAlignCellWithSp/> <w:DontBreakConstrainedForcedTables/> <w:DontVertAlignInTxbx/> <w:Word11KerningPairs/> <w:CachedColBalance/> <w:UseFELayout/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true" DefSemiHidden="true" DefQFormat="false" DefPriority="99" LatentStyleCount="267"> <w:LsdException Locked="false" Priority="0" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false" UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;} </style> <![endif]--> [TABLE="class: MsoNormalTable, width: 762"]
<tbody>[TR]
[TD="width: 29"][/TD]
[TD="width: 299"]
A​
[/TD]
[TD="width: 204"]
B​
[/TD]
[TD="width: 25"]
C​
[/TD]
[TD="width: 68"]
D​
[/TD]
[TD="width: 36"]
E​
[/TD]
[TD="width: 68"]
F​
[/TD]
[TD="width: 36"]
G​
[/TD]
[TD="width: 88"]
H​
[/TD]
[TD="width: 68"][/TD]
[TD="width: 68"][/TD]
[TD="width: 27"][/TD]
[/TR]
[TR]
[TD="width: 29"]
1​
[/TD]
[TD="width: 299"]
TEAM​
[/TD]
[TD="width: 204"]
[/TD]
[TD="width: 25"]
[/TD]
[TD="width: 296, colspan: 5"] Total Bet Amount has to be £10!!!
[/TD]
[TD="width: 68"]
​
[/TD]
[TD="width: 68"]
​
[/TD]
[TD="width: 27"]
​
[/TD]
[/TR]
[TR]
[TD="width: 29"]
2​
[/TD]
[TD="width: 299"]
​
[/TD]
[TD="width: 204"][/TD]
[TD="width: 25"][/TD]
[TD="width: 68"]
Amount​
[/TD]
[TD="width: 36"][/TD]
[TD="width: 68"]
Odds​
[/TD]
[TD="width: 36"][/TD]
[TD="width: 88"]
Bet Return​
[/TD]
[TD="width: 68"][/TD]
[TD="width: 68"][/TD]
[TD="width: 27"]
​
[/TD]
[/TR]
[TR]
[TD="width: 29"]
3​
[/TD]
[TD="width: 299"] Liverpool to Win the match
[/TD]
[TD="width: 204"][/TD]
[TD="width: 25"][/TD]
[TD="width: 68"]
£1.20​
[/TD]
[TD="width: 36"][/TD]
[TD="width: 68"]
1.200​
[/TD]
[TD="width: 36"][/TD]
[TD="width: 88"]
£1.44​
[/TD]
[TD="width: 68"][/TD]
[TD="width: 68"][/TD]
[TD="width: 27"]
​
[/TD]
[/TR]
[TR]
[TD="width: 29"]
4​
[/TD]
[TD="width: 299"] Liverpool to win 1st half & win the match
[/TD]
[TD="width: 204"][/TD]
[TD="width: 25"][/TD]
[TD="width: 68"]
???​
[/TD]
[TD="width: 36"][/TD]
[TD="width: 68"]
1.500​
[/TD]
[TD="width: 36"][/TD]
[TD="width: 88"]
#VALUE!​
[/TD]
[TD="width: 68"][/TD]
[TD="width: 68"][/TD]
[TD="width: 27"]
​
[/TD]
[/TR]
[TR]
[TD="width: 29"]
5​
[/TD]
[TD="width: 299"] Liverpool to draw 1st half & win the match
[/TD]
[TD="width: 204"][/TD]
[TD="width: 25"][/TD]
[TD="width: 68"]
???​
[/TD]
[TD="width: 36"][/TD]
[TD="width: 68"]
1.600​
[/TD]
[TD="width: 36"][/TD]
[TD="width: 88"]
#VALUE!​
[/TD]
[TD="width: 68"][/TD]
[TD="width: 68"][/TD]
[TD="width: 27"]
​
[/TD]
[/TR]
[TR]
[TD="width: 29"]
6​
[/TD]
[TD="width: 299"]
[/TD]
[TD="width: 204"][/TD]
[TD="width: 25"][/TD]
[TD="width: 68"][/TD]
[TD="width: 36"][/TD]
[TD="width: 68"][/TD]
[TD="width: 36"][/TD]
[TD="width: 88"][/TD]
[TD="width: 68"][/TD]
[TD="width: 68"][/TD]
[TD="width: 27"]
​
[/TD]
[/TR]
[TR]
[TD="width: 29"]
7​
[/TD]
[TD="width: 503, colspan: 2"] You can see by my example above that cell D3 has to equal cell F3.
[/TD]
[TD="width: 25"][/TD]
[TD="width: 68"][/TD]
[TD="width: 36"][/TD]
[TD="width: 68"][/TD]
[TD="width: 36"][/TD]
[TD="width: 88"][/TD]
[TD="width: 68"][/TD]
[TD="width: 68"][/TD]
[TD="width: 27"]
​
[/TD]
[/TR]
[TR]
[TD="width: 29"]
8​
[/TD]
[TD="width: 299"]
[/TD]
[TD="width: 204"][/TD]
[TD="width: 25"][/TD]
[TD="width: 296, colspan: 5"] Total Bet Amount has to be £10!!!
[/TD]
[TD="width: 68"][/TD]
[TD="width: 68"][/TD]
[TD="width: 27"]
​
[/TD]
[/TR]
[TR]
[TD="width: 29"]
9​
[/TD]
[TD="width: 299"]
​
[/TD]
[TD="width: 204"][/TD]
[TD="width: 25"][/TD]
[TD="width: 68"]
Amount​
[/TD]
[TD="width: 36"][/TD]
[TD="width: 68"]
Odds​
[/TD]
[TD="width: 36"][/TD]
[TD="width: 88"]
Bet Return​
[/TD]
[TD="width: 68"][/TD]
[TD="width: 68"][/TD]
[TD="width: 27"]
​
[/TD]
[/TR]
[TR]
[TD="width: 29"]
10​
[/TD]
[TD="width: 299"] Liverpool to Win the match
[/TD]
[TD="width: 204"][/TD]
[TD="width: 25"][/TD]
[TD="width: 68"]
£1.20​
[/TD]
[TD="width: 36"][/TD]
[TD="width: 68"]
1.200​
[/TD]
[TD="width: 36"][/TD]
[TD="width: 88"]
£1.44​
[/TD]
[TD="width: 68"][/TD]
[TD="width: 68"][/TD]
[TD="width: 27"]
​
[/TD]
[/TR]
[TR]
[TD="width: 29"]
11​
[/TD]
[TD="width: 299"] Liverpool to win 1st half & win the match
[/TD]
[TD="width: 204"][/TD]
[TD="width: 25"][/TD]
[TD="width: 68"]
£4.40​
[/TD]
[TD="width: 36"][/TD]
[TD="width: 68"]
1.500​
[/TD]
[TD="width: 36"][/TD]
[TD="width: 88"]
£6.60​
[/TD]
[TD="width: 68"][/TD]
[TD="width: 68"][/TD]
[TD="width: 27"]
​
[/TD]
[/TR]
[TR]
[TD="width: 29"]
12​
[/TD]
[TD="width: 299"] Liverpool to draw 1st half & win the match
[/TD]
[TD="width: 204"][/TD]
[TD="width: 25"][/TD]
[TD="width: 68"]
£4.40​
[/TD]
[TD="width: 36"][/TD]
[TD="width: 68"]
1.600​
[/TD]
[TD="width: 36"][/TD]
[TD="width: 88"]
£7.04​
[/TD]
[TD="width: 68"][/TD]
[TD="width: 68"][/TD]
[TD="width: 27"]
​
[/TD]
[/TR]
[TR]
[TD="width: 29"]
13​
[/TD]
[TD="width: 299"]
[/TD]
[TD="width: 204"][/TD]
[TD="width: 25"][/TD]
[TD="width: 68"][/TD]
[TD="width: 36"][/TD]
[TD="width: 68"][/TD]
[TD="width: 36"][/TD]
[TD="width: 88"][/TD]
[TD="width: 68"][/TD]
[TD="width: 68"][/TD]
[TD="width: 27"]
​
[/TD]
[/TR]
[TR]
[TD="width: 29"]
14​
[/TD]
[TD="width: 987, colspan: 11"] In my second example above i have inserted a value of £4.40 in to cells D11(£4.40) and D12(£4.40), ((£4.40+£4.40+£1.20=£10))which results in
[/TD]
[/TR]
[TR]
[TD="width: 29"]
15​
[/TD]
[TD="width: 299"] the values for H11(£6.60) and H12(£7.04).
[/TD]
[TD="width: 204"][/TD]
[TD="width: 25"][/TD]
[TD="width: 68"][/TD]
[TD="width: 36"][/TD]
[TD="width: 68"][/TD]
[TD="width: 36"][/TD]
[TD="width: 88"][/TD]
[TD="width: 68"][/TD]
[TD="width: 68"][/TD]
[TD="width: 27"]
​
[/TD]
[/TR]
[TR]
[TD="width: 29"]
16​
[/TD]
[TD="width: 299"]
[/TD]
[TD="width: 204"][/TD]
[TD="width: 25"][/TD]
[TD="width: 68"][/TD]
[TD="width: 36"][/TD]
[TD="width: 68"][/TD]
[TD="width: 36"][/TD]
[TD="width: 88"][/TD]
[TD="width: 68"][/TD]
[TD="width: 68"][/TD]
[TD="width: 27"]
​
[/TD]
[/TR]
[TR]
[TD="width: 29"]
17​
[/TD]
[TD="width: 987, colspan: 11"] Looking back at my first example my question is:- How can i write a formula that calculates the cells D4 and D5 in order for cells H4 and H5 to
[/TD]
[/TR]
[TR]
[TD="width: 29"]
18​
[/TD]
[TD="width: 528, colspan: 3"] give an equal return value(give or take a penny)??? As like example below.
[/TD]
[TD="width: 68"][/TD]
[TD="width: 36"][/TD]
[TD="width: 68"][/TD]
[TD="width: 36"][/TD]
[TD="width: 88"][/TD]
[TD="width: 68"][/TD]
[TD="width: 68"][/TD]
[TD="width: 27"]
​
[/TD]
[/TR]
[TR]
[TD="width: 29"]
19​
[/TD]
[TD="width: 299"]
[/TD]
[TD="width: 204"][/TD]
[TD="width: 25"][/TD]
[TD="width: 68"][/TD]
[TD="width: 36"][/TD]
[TD="width: 68"][/TD]
[TD="width: 36"][/TD]
[TD="width: 88"][/TD]
[TD="width: 68"][/TD]
[TD="width: 68"][/TD]
[TD="width: 27"]
​
[/TD]
[/TR]
[TR]
[TD="width: 29"]
20​
[/TD]
[TD="width: 299"]
[/TD]
[TD="width: 204"][/TD]
[TD="width: 25"][/TD]
[TD="width: 296, colspan: 5"] Total Bet Amount has to be £10!!!
[/TD]
[TD="width: 68"][/TD]
[TD="width: 68"][/TD]
[TD="width: 27"]
​
[/TD]
[/TR]
[TR]
[TD="width: 29"]
21​
[/TD]
[TD="width: 299"]
​
[/TD]
[TD="width: 204"][/TD]
[TD="width: 25"][/TD]
[TD="width: 68"]
Amount​
[/TD]
[TD="width: 36"][/TD]
[TD="width: 68"]
Odds​
[/TD]
[TD="width: 36"][/TD]
[TD="width: 88"]
Bet Return​
[/TD]
[TD="width: 68"][/TD]
[TD="width: 68"][/TD]
[TD="width: 27"]
​
[/TD]
[/TR]
[TR]
[TD="width: 29"]
22​
[/TD]
[TD="width: 299"] Liverpool to Win the match
[/TD]
[TD="width: 204"][/TD]
[TD="width: 25"][/TD]
[TD="width: 68"]
£1.20​
[/TD]
[TD="width: 36"][/TD]
[TD="width: 68"]
1.200​
[/TD]
[TD="width: 36"][/TD]
[TD="width: 88"]
£1.44​
[/TD]
[TD="width: 68"][/TD]
[TD="width: 68"][/TD]
[TD="width: 27"]
​
[/TD]
[/TR]
[TR]
[TD="width: 29"]
23​
[/TD]
[TD="width: 299"] Liverpool to win 1st half & win the match
[/TD]
[TD="width: 204"][/TD]
[TD="width: 25"][/TD]
[TD="width: 68"]
£4.54​
[/TD]
[TD="width: 36"][/TD]
[TD="width: 68"]
1.500​
[/TD]
[TD="width: 36"][/TD]
[TD="width: 88"]
£6.81​
[/TD]
[TD="width: 68"][/TD]
[TD="width: 68"][/TD]
[TD="width: 27"]
​
[/TD]
[/TR]
[TR]
[TD="width: 29"]
24​
[/TD]
[TD="width: 299"] Liverpool to draw 1st half & win the match
[/TD]
[TD="width: 204"][/TD]
[TD="width: 25"][/TD]
[TD="width: 68"]
£4.26​
[/TD]
[TD="width: 36"][/TD]
[TD="width: 68"]
1.600​
[/TD]
[TD="width: 36"][/TD]
[TD="width: 88"]
£6.82​
[/TD]
[TD="width: 68"][/TD]
[TD="width: 68"][/TD]
[TD="width: 27"]
​
[/TD]
[/TR]
[TR]
[TD="width: 29"]
25​
[/TD]
[TD="width: 299"]
[/TD]
[TD="width: 204"][/TD]
[TD="width: 25"][/TD]
[TD="width: 68"][/TD]
[TD="width: 36"][/TD]
[TD="width: 68"][/TD]
[TD="width: 36"][/TD]
[TD="width: 88"][/TD]
[TD="width: 68"][/TD]
[TD="width: 68"][/TD]
[TD="width: 27"]
​
[/TD]
[/TR]
[TR]
[TD="width: 29"]
26​
[/TD]
[TD="width: 299"]
[/TD]
[TD="width: 204"][/TD]
[TD="width: 25"][/TD]
[TD="width: 68"][/TD]
[TD="width: 36"][/TD]
[TD="width: 68"][/TD]
[TD="width: 36"][/TD]
[TD="width: 88"][/TD]
[TD="width: 68"][/TD]
[TD="width: 68"][/TD]
[TD="width: 27"]
​
[/TD]
[/TR]
[TR]
[TD="width: 29"]
27​
[/TD]
[TD="width: 503, colspan: 2"] Any help would be much appreciated.
[/TD]
[TD="width: 25"]
[/TD]
[TD="width: 68"]
​
[/TD]
[TD="width: 36"]
​
[/TD]
[TD="width: 68"]
​
[/TD]
[TD="width: 36"]
​
[/TD]
[TD="width: 88"]
​
[/TD]
[TD="width: 68"]
​
[/TD]
[TD="width: 68"]
​
[/TD]
[TD="width: 27"]
​
[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Sort by date Sort by votes
Re: Can anyone help me Solve my Formula problem Please?

Thank you njimack. I replaced your example above with D4: =(10-d3)/sum($f$4:$f$5)*f5 and it works a treat. I have been trying to solve this for nearly a month lol!! Thank you so much for solving this for me!!!:smile:
 
Upvote 0
Re: Can anyone help me Solve my Formula problem Please?

Could you also please help me with the equation if i wanted to add another 3 rows of bets to my existing 3 bets. Thanks.
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Solved
Format & Protect range of cells using VBA
Replies
7
Views
842
Gajendran Yadhav
G
P
  • Question Question
Automatically inserting VBA into a workbook
Replies
1
Views
1K
Phillip2
P
S
  • Question Question
Type mismatch using date in InputBox
Replies
1
Views
1K
SeniorTom
S
Gerald Higgins
  • Question Question
VBA, make code move across from main file to extract file
Replies
9
Views
2K
Gerald Higgins
Gerald Higgins
P
  • Question Question
Using Lastrow
Replies
6
Views
1K
DanteAmor
DanteAmor

Forum statistics

Threads
1,223,904
Messages
6,175,295
Members
452,631
Latest member
a_potato

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top