Negative percent formula

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

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



"Bob" <[email protected]> wrote in message
news:[email protected]...
> 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

Thank you very much

"CLR" wrote:

> 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
>
>
>
> "Bob" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>