Excel Percentage help!

[Shift838]

I am having an issue calculating percentages correctly. I have 2 colums that are general number format. say colum A for baseline and B for actual time in seconds. column C is for the percenage result. I want column C to show the increase of percentage.

For instance

A1 = 8
B1 = 7
C1 is a forumular for B1/A1 and excel shows it to be:

87.5

I know this is not the correct percentage.

I beleive if I take 87.5 and subtract it from 100 to get 12.5 is the correct answere to show that there was a 12.5% better time.

Is there a simpler way to do this?

 

[SkipVought]

Would it not be ...
[tt]
=Abs(A1-B1)/A1
[/tt]


Skip,

_{I'll be dressed to the nines this week, as I go to have my prostatectomy...
Because, if I'm gonna BE impotent, I want to LOOK impotent!}

 

[Lilliabeth]

http://www.dataschenk.com/Tips/ExPercent.htm

Lilliabeth
-Why use a big word when a diminutive one will do?-