formula in excell

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I'm trying to find the formula that will calculate the
percentage gain or loss, between two numbers
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating Hypothetical Growth of $10,000 in Excel 3
Excel formula 3
using dates and time in formulas 1
Formulas in Pivot Table 4
How do I calculate variance percetage if figures are negative 5
Can you convert 120lbs to show as 8st 8lbs? 6
Formula doesn't work unless hit enter again 5
How do I make this formula? 1

Back
Top