OZmium Sports Betting and Horse Racing Forums

OZmium Sports Betting and Horse Racing Forums (http://forums.ozmium.com.au/index.php)
-   Horse Race Betting Systems (http://forums.ozmium.com.au/forumdisplay.php?f=10)
-   -   Excel string help (http://forums.ozmium.com.au/showthread.php?t=15757)

Crackone 22nd April 2007 09:14 AM

Quote:
Originally Posted by moeee
looks a bit untidy but will do the job

=IF(H2 =1,X1,IF(H2 =2,X1,IF(H2 =3,X1,0)))

Where X1 is the cell containing your Profit /loss Formula
Thanks for your help ended up with =IF(H2 <4,F2*E2-(D2*F2),(F2*0)) does the job


All times are GMT +10. The time now is 10:27 PM.

Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.