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 %

 

[Rafael Ortiz]

Usually the formula is like this:

=(D2-B2)/B2

then format the result as a percent.

MRO

 

[J.E. McGimpsey]

That formula is less efficient than

=D2/B2 - 1

since B2 has to be looked up twice.

 

[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