Invert a % value

[bobgrand]

Hello all,

I need to invert a percentage value. Example,,, 80.64% How do I make this show the inverted value of 19.36.

I tried many different ways and can't seem to get. Go ahead and laugh while I sit here and scratch my head, lol lol

As always any help would be greatly appreciated

Thanks
Bob

 

[Tubal]

Assume 80.64% is stored as 0.8064, then NewPct = 1 - 0.8064.

 

[bobgrand]

I feel like such a fool.

Thank you

 

[joeu2004]

Assume 80.64% is stored as 0.8064, then NewPct = 1 - 0.8064.

You can also write 1 - 80.64%. No need to convert to a decimal fraction.