I am trying to set up a formula that is stumping me.
I will put an example, because it is probably easier.
If I enter a number into a cell I want it to turn that number into the
difference between the number and 100 and then into a percentage.

Ex: 88.7 entered into the cell.
Formula changes it into 11.3%

Hopefully thats clear.

in B1 formatted as %:

=(100-A1)/100

A1=88.7
B1=11.3%

Is this what you want?


"JustOneJawa" wrote:

I am trying to set up a formula that is stumping me.
I will put an example, because it is probably easier.
If I enter a number into a cell I want it to turn that number into the
difference between the number and 100 and then into a percentage.

Ex: 88.7 entered into the cell.
Formula changes it into 11.3%

Hopefully thats clear.

In A1 input 88.7, in B1 using % format insert formula 1-(A1/100). You can not
insert the number in the same sell where the formula resides.

"JustOneJawa" wrote:

I am trying to set up a formula that is stumping me.
I will put an example, because it is probably easier.
If I enter a number into a cell I want it to turn that number into the
difference between the number and 100 and then into a percentage.

Ex: 88.7 entered into the cell.
Formula changes it into 11.3%

Hopefully thats clear.