New Posts For Thread: Simple Excel Formula Needed

Cheers toprated, I've sorted it now.

Fri, 23 Dec 2011 14:43:07 -0600

Cheers toprated, I've sorted it now.

Usual problem displaying the less than and greater than characters I'll try again......=IF(K2 < > "",IF(K2=1,H20.95,-(I2-1)H2),"")

Fri, 23 Dec 2011 14:31:27 -0600

Usual problem displaying the less than and greater than characters I'll try again......=IF(K2 < > "",IF(K2=1,H2*0.95,-(I2-1)*H2),"")

H I J K L 1 Stake Odds Bookie Win (1) / Lose (0) P/L 2 10.00 1.34 0 -3.40 Insert the formula below in cell L2=IF(K2"",IF(K2=1,H2*

Fri, 23 Dec 2011 14:28:35 -0600

H I J K L 1 Stake Odds Bookie Win (1) / Lose (0) P/L 2 10.00 1.34 0 -3.40 Insert the formula below in cell L2=IF(K2"",IF(K2=1,H2*

For a simple person seeing as Excel is not my strong point.I know how to formulate a backing spreadsheet, but looking for a laying formula.H = StakeI = OddsJ = BookieK = W/LL = P/LWhat I want to know is what should be in "L"For example, I lay somethi

Fri, 23 Dec 2011 13:32:47 -0600

For a simple person seeing as Excel is not my strong point.I know how to formulate a backing spreadsheet, but looking for a laying formula.H = StakeI = OddsJ = BookieK = W/LL = P/LWhat I want to know is what should be in "L"For example, I lay somethi