Percent

  • Thread starter Thread starter Old Red One
  • Start date Start date
Old Red One said:
How is the formula for percent change between two numbers constructed and
entered?
Click to expand...

Hi Red,

This will calculate the percentage increase from 30 to 45 (50% increase):

=(45-30)/30 = 50%


This will calculate the percentage decrease from 45 to 30 (33.3% decrease):

=(30-45)/45 = -33.3%


HTH,

Alan.
 

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

How to Populate Data from a table to another 0
Help with formula... 1
How can I find the percent differnce between two numbers? 1
Help with a range formula 4
Help with a formula 2
Combining Percent with Text 5
Average Formula Help 2
Monthly Percent Increase 1

Back
Top