easy question, but not to me

[L. T. Portella]

a b c d e
f
Purchase Purchase Today's Market $ Profit % Profit
Date Price Date Value
1/1/02 100.00 9/4/03 150.00 50.00

given the above, what is the formula that I should put in column f to get
the percentage profit

Many thanks

 

[Harald Staff]

Hi

=D2/B2-1
format result cell as %

 

[you suck]

it depends whether you want the percentage on the market value or the
percentageon the purchase price

 

[Pmxgs]

you have to divide the profit per purchase price (= e/b) or = (d-b)/b