I'm trying to find the formula that will calculate the percentage gain or loss, between two numbers
B Bill Sep 11, 2003 #1 I'm trying to find the formula that will calculate the percentage gain or loss, between two numbers
J J.E. McGimpsey Sep 11, 2003 #2 One way: =B1/A1 - 1 (which is a bit more efficent than (B1-A1)/A1, since A1 only has to be looked up once). Format as a percentage.
One way: =B1/A1 - 1 (which is a bit more efficent than (B1-A1)/A1, since A1 only has to be looked up once). Format as a percentage.
