easy question, but not to me

  • Thread starter Thread starter L. T. Portella
  • Start date Start date
L

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
 
Usually the formula is like this:

=(D2-B2)/B2

then format the result as a percent.

MRO
 
That formula is less efficient than

=D2/B2 - 1

since B2 has to be looked up twice.
 
it depends whether you want the percentage on the market value or the
percentageon the purchase price
 
Back
Top