Negative percent formula

[Guest]

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

 

[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

 

[Guest]

Thank you very much

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