In excel reverse a minus figure to a plus -1.81 to 1.81

D

Dave Newman

If I have two figures and I want the % difference I use
=SUM(((111000/113040.55)*100)-100)
This comes out -1.81 but it should be 1.81

Anyone got any clues
 
D

Don Guillett

cuz that's what it is
use a -in front
=(111000/113040.55)*100-100
=-(111000/113040.55)*100-100
 
D

David Biddulph

Firstly, why are you using the SUM() function? What list of numbers are you
asking it to add?

Secondly, why do you say the percentage difference should be +1.81?
The difference from 111000 to 113040.55 =100*(113040.55/111000-1), or just
=113040.55/111000-1 formatted as a percentage, which is 1.84%.
The difference the other way (from 113040.55 to 111000) is the answer you've
got, -1.81%.

If you really want to get +1.81% you could use =100-(111000/113040.55)*100
or =1-111000/113040.55 formatted as a percentage, but that isn't a
percentage difference.
 
M

MyVeryOwnSelf

If I have two figures and I want the % difference I use
=SUM(((111000/113040.55)*100)-100)
This comes out -1.81 but it should be 1.81

Anyone got any clues
Click to expand...

You seem to want the answer to be positive regardless of which number is
bigger.

If so, maybe this would help:
=ABS(((111000/113040.55)*100)-100)
 
Top