Inverting percentages

[kittymongo]

Hello, i am new here.

i am trying to find a formula to invert percentages. Example - if a payment is paying out 125% correct, i need it to reflect 75% correct. if it is paying 199% correct then i need a formula to read it as 1%.

i hope someone can help!

Thank you

 

[Joe4]

Welcome to the Board!

Looks like you just want 200% minus the percent you have, i.e.
=200% - A1
if your percentage is in A1

 

[JumpingCrab]

If the original percentage is in A1, the formula in B1 for the 'inverse' as you mention, would be

B1 = 200%-A1

 

[kittymongo]

Oh my goodness, thank you! This just made my life significantly easier.