ExcelBanter - difference in percentange

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - difference in percentange (https://www.excelbanter.com/excel-discussion-misc-queries/258797-difference-percentange.html)

Caribbrz

difference in percentange

This is probably a very easy question....

I have the following

cell D cell E
484 526

In cell F I want to show the difference in a percentage. I currently have
the following format
(D1-E10/D1 but it gives me a -9%....when it is actaully an
increase....what am I doing wrong?

Fred Smith[_4_]

difference in percentange

Then you want:
=(E1-D1)/D1

Regards,
Fred

"Caribbrz" wrote in message
...
This is probably a very easy question....

I have the following

cell D cell E
484 526

In cell F I want to show the difference in a percentage. I currently
have
the following format
(D1-E10/D1 but it gives me a -9%....when it is actaully an
increase....what am I doing wrong?

Dave Peterson

difference in percentange

How about:

=(e1-d1)/d1

Caribbrz wrote:

This is probably a very easy question....

I have the following

cell D cell E
484 526

In cell F I want to show the difference in a percentage. I currently have
the following format
(D1-E10/D1 but it gives me a -9%....when it is actaully an
increase....what am I doing wrong?

--

Dave Peterson

All times are GMT +1. The time now is 09:14 AM.