percentage difference

  • Thread starter cimarron trucking
  • Start date
C

cimarron trucking

What function can I use/make to figure the difference in percentage between 2
monetary amounts?
 
H

Harald Staff

Hi

40 in A1. 80 in B1. In C1 formula
=A1/B1
format as percent numberformat and you may discover that 40 is 50% of 80.

HTH. Best wishes Harald
 
B

Bernard Liengme

I think OP wants the <difference>:
=(B1-A1)/A1 or =B1/A1 - 1
format as percentage
 
J

John Mansfield

I would use the formula

=(B1-A1)/abs(A1)

where the data in B1 is new and the data in A1 is what you want to compare
to. The reference to the absolute value in the denominator insures that the
percent change signs are correct if and when a negative number were to occur.
 

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

Resource name inside resource sheet: per person, work per hours per week 0
Number range as a percentage 2
How do I make column C a percentage of column B 3
Percentage of Weight Loss/Gain 4
physical percentage formula 1
Percentage Increase 11
Average function for letters 3
Convert numbers stored as text to numbers - Automatically (NO Macrosor VBA) 0

Top