22nd April 2007, 09:14 AM
|
|
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 |