View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Carim Carim is offline
external usenet poster
 
Posts: 510
Default 2 formula for 1 cell

Hi,

Well, if you decide to pick column A for all your purchases, and column
B for all your sales,
you could have in column C the following formula :
=(B2-A2)*10000
which would calculate your P/L on each trade ...

HTH
Carim