Percent change

Giganews Newsgroups
Subject: Percent change
Posted by:  cardfan057
Date: Tue, 9 May 2006

I need a formula that will show percent change from the pervious month, the
one I came up with is =SUM((D19-B19)/B19), but this isn't accurate when the
previous month is a loss(-) ie. h19 & f19.

                                      Jan              Feb
March          Apr
Net Income(Loss)    (B19)363      (D19)15        (F19)-572      (H19)411    
Percent of Change                        

--
cardfan057

Replies