View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael
 
Posts: n/a
Default Function Question

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.