% of increase or decrease formula

[elvezrulz]

I need a formula that will take 2 numbers and spit out the percentage of increase or decrease. Thank you in advance.

 

[DauntingGecko]

Smallest number - Biggest number. Format as percentage.

???

 

[elvezrulz]

That doesn't work for this because I need it to understand that on it's own. I have way too many cells to do each one manually like that.

 

[JackDanIce]

Does this work:

=IF(A1>B1,B1-A1,A1-B1)

Formatted (as suggested) as percent? You can then drag this formula down for your rows

 

[JackDanIce]

Re-reading your original post, asking for increase or decrease, do you mean it'll always be the change from the value in 1st column to the value in the second column? If so, then can't you just use:

=(B1-A1)/B1

Then format as percentage and drag down all your rows?

 

[elvezrulz]

Re-reading your original post, asking for increase or decrease, do you mean it'll always be the change from the value in 1st column to the value in the second column? If so, then can't you just use:

=(B1-A1)/B1

Then format as percentage and drag down all your rows?

Yes, that works. I was confused because someone here at work had given me some convoluted formula and it was spitting out really weird results. Very simple, many thanks!

 

[JackDanIce]

No worries