Thread: Excel string help
View Single Post
  #10  
Old 21st April 2007, 10:17 PM
moeee moeee is offline
Suspended
  
Join Date: Jan 1970
Location: Melbourne
Posts: 5,359
Default Try This
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
Reply With Quote