OZmium Sports Betting and Horse Racing Forums

#11

22nd April 2007, 09:14 AM

Crackone

Member

Join Date: Apr 2006

Posts: 368

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

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is On

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

	To advertise on these forums, e-mail us.