negative percentage

[Gettingbetter15]

Hi!
I'm trying to figure out how to do the formula for: 893.30 (A1) is a negative percentage of 1393.30 (B1). I've figured out that:
=(B1/A1)-1 = 0.559723. But I'm looking for the opposite...that A1 = -.44027 (a 44% loss of the original value) and I just don't know how to make Excel give me THAT without doing it manually...any help would be greatly appreciated! TIA!

 

[veryamusing]

=(B1-A1)/A1-1 = -0.44027762229934

But I think the correct answer to the "percent change to 893.30 from 1393.30" is "After divided by Before minus one":

=A1/B1-1 = -0.358860259814828

Because -0.358860259814828 * 1393.30 = -500

Another way: you could also have (After minus Before) divided by Before: =(A1-B1)/B1

 

[Gettingbetter15]

Thank you so much, veryamusing! I didn't even see the error you saw and correctedy!!!! That's exactly what I needed. Have a great New Year!