golfgirl46
New Member
- Joined
- Jun 6, 2008
- Messages
- 12
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!
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!