Function Question
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.
|