Reversing the result of a formula

B

bobjglover@gmail.com

New member
Joined
Aug 3, 2015
Messages
57
Reaction score
0
Points
0
Excel Version(s)
1901
I need to reverse the result of a formula x/y = % based on the 2 data fields, and can't seem to figure it out because its too simple...

x=$43.96/ y=$45.11 = 2.62% <-- I need it to show a negative. (Current formula is =K6/G6-100%).

This is embarrassing....
 
bobjglover@gmail.com said:
I need to reverse the result of a formula x/y = % based on the 2 data fields, and can't seem to figure it out because its too simple...

x=$43.96/ y=$45.11 = 2.62% <

Might have the wrong end the stick here, but with the values you have, it would need to be y/x in order to return 2.62. To return -2.62, format the cell as a percentage and enter (-y/x) +1
Click to expand...
 
bobjglover@gmail.com said:
I need to reverse the result of a formula x/y = % based on the 2 data fields, and can't seem to figure it out because its too simple...

x=$43.96/ y=$45.11 = 2.62% <-- I need it to show a negative. (Current formula is =K6/G6-100%).

This is embarrassing....
Click to expand...

Sorry - I keep running into problems when I post from Windows Explorer - Try again

Might have the wrong end of the stick here, but with the values you have, it would need to be y/x in order to return 2.62. To return -2.62, format the cell as a percentage and enter (-y/x) +1
Doing it your way with (x/y) -1 gives only -2.55%
 
thanks yes I had it inadvertently reversed above, I actually figured it out with this =0-x/y+100%, pretty much the same as yours.
 
You must log in or register to reply here.
Back
Top