Percentage-difference

  • Thread starter Thread starter gary
  • Start date Start date
G

gary

(I must be brain-dead).

Here's my worksheet:

A B C D

TIME INTEREST
PRINCIPAL RATE (months) (P*R*T)

1 100.00 0.015 62 93.00
2 100.00 0.015 50 75.00
3 100.00 0.015 38 57.00
4 100.00 0.015 26 39.00
5 100.00 0.015 14 21.00

How can I compute the percentage-difference between each
interest-amount?

Thanks,

Gary
 
In E2 = (D2-D1)/D1 and format as Percent. This, of course is the same as
D2/D1-1
A percent is merely a fraction multiplied by 100.
Best wishes
Bernard
 
Then just

=(D1-D2)/D2 ???

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top