View Single Post
  #4   Report Post  
Joe User
 
Posts: n/a
Default

Gord Dibben <gorddibbATshawDOTca wrote:
A1 contains 50
B1 contains 25
In C1 enter =A1/B1 and format as "percent" to get 50% in C1


Gee, I hope not. A1/B1 = 2 = 200%. Just tried it.
Thankfully, this is human error. Excel does it right.

The correct formula is =(A1-B1)/B1 to determine how A1
has grown compared to B1 (i.e, "A1 is x% more [or less]
than B1"). The formula is =(B1-A1)/A1 to determine how
B1 has grown compared to A1.

But that is the answer to the second question, not the
first question.

MayBee wrote:
Calculate percentage of fund growth in past yeras;
also percentage relationship of 1 # to another