leopardhawk
Well-known Member
- Joined
- May 31, 2007
- Messages
- 611
- Office Version
- 2016
- Platform
- Windows
Hello forum friends,
Can someone please suggest an Excel formula to handle this simple task? I'm trying to show a Percent Difference between two variables. The result should always be a positive number.
When I enter it into Excel the way I see it on paper, using two variables (21940 and 21866) I get a return of 5000 when in actual fact, the answer is .337853
21940-21866 divided by 21940+21866 divided by 2 multiplied by 100
Also, the two variables should be able to be transposed with the results being the same.
Thanks!
Can someone please suggest an Excel formula to handle this simple task? I'm trying to show a Percent Difference between two variables. The result should always be a positive number.
When I enter it into Excel the way I see it on paper, using two variables (21940 and 21866) I get a return of 5000 when in actual fact, the answer is .337853
21940-21866 divided by 21940+21866 divided by 2 multiplied by 100
Also, the two variables should be able to be transposed with the results being the same.
Thanks!