# simple formula?

#### golfgirl46

##### New Member
I'm sure this is easy, but I'm stuck.

I have an original value and a current value. I want to calculate the percentage increase or decrease from the original and if the value has dropped, I want that to be a negative number.

Example:
Original value \$420000 (A1)
Current value \$192000 (A2)
Current fomula =(A1-B1)/ABS(A1) which gives me 54% but I would like that number to be negative.

I have about 200 cells to apply this formula to so I was hoping for a formula that would work wether the number was an increase or a decrease.

Thanks!

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Isn't it?

=(A2/A1)-1

I think it is

=((A1-A2)/A1)*-1

Works for me

Cheers
GB

I knew it was easy!
Thanks a bunch!

Replies
3
Views
326
Replies
2
Views
176
Replies
5
Views
121
Replies
2
Views
579
Replies
4
Views
191

1,196,368
Messages
6,014,854
Members
441,850
Latest member
peh16

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back