Correct formula for a percentage comparison of two fields

Hello,

I am trying to compare to fields to obtain a percentage difference whether positive or negative. The first formula I utilized was (b11-a11)/b11. This gave me a negative percentage amount of -798%. The amount should be no more than 100% or -100%. Then I tried (b11/a11)-1 and the number i got was -88% which seems to make sense. Why did this occur? Oh yeah B11 = $36,400 and A11 = $327,120.

Lastly, for my other comparisons within my worksheet, the formula of (b#-a#)/b# seems to get me the correct percentage difference. The only time the (b#/a#)-1 seemed to work was for my example I listed above. I am wondering why is this the case.

Thanks for your assistance.
Hector

Hello,

Thank you for your assistance.

Here are the values:

#1 Example - B11 = $36,400 A11 = $327,120
#2 Example - B13 = $8,190,758.13 A13 = $9,165,089.69
#3 Example - B49 = $6,389,492.47 A49 =$5,270,564.57

Thanks again.
Hector

Thank you for info. This has really helped!