Home |
Search |
Today's Posts |
#1
|
|||
|
|||
percentage difference
What function can I use/make to figure the difference in percentage between 2
monetary amounts? |
#2
|
|||
|
|||
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 "cimarron trucking" <cimarron skrev i melding ... What function can I use/make to figure the difference in percentage between 2 monetary amounts? |
#3
|
|||
|
|||
I think OP wants the <difference:
=(B1-A1)/A1 or =B1/A1 - 1 format as percentage -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in email address "Harald Staff" wrote in message ... 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 "cimarron trucking" <cimarron skrev i melding ... What function can I use/make to figure the difference in percentage between 2 monetary amounts? |
#4
|
|||
|
|||
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. "Bernard Liengme" wrote: I think OP wants the <difference: =(B1-A1)/A1 or =B1/A1 - 1 format as percentage -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in email address "Harald Staff" wrote in message ... 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 "cimarron trucking" <cimarron skrev i melding ... What function can I use/make to figure the difference in percentage between 2 monetary amounts? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
Generating a percentage... | Excel Discussion (Misc queries) | |||
changing the value of each cell in a range by a certain percentage | Excel Discussion (Misc queries) | |||
How do you calculate the difference between two values within a p. | Excel Discussion (Misc queries) | |||
What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel |