Negative percent formula

B

Bob

I want to run a spreadsheet with this info
Period 1 2 3 4
This yr -1% +2% -2% -3%
How do i show an increase/decrease per period
I can do this on positive numbers, say b1/a1-1, but with minus and pluses it
shows a different result
Open to suggestions please
 
C

CLR

First, make sure your Percentage values are actually numbers, not
TEXT..........then, assuming your data is in cells A1:E2, then in C3 put
this formula..........

=C2-(B2)

Drag it to E3 and format those cells for %

Vaya con Dios,
Chuck, CABGx3
 
B

Bob

Thank you very much

CLR said:
First, make sure your Percentage values are actually numbers, not
TEXT..........then, assuming your data is in cells A1:E2, then in C3 put
this formula..........

=C2-(B2)

Drag it to E3 and format those cells for %

Vaya con Dios,
Chuck, CABGx3
Click to expand...
 
Top