% of increase or decrease
Assuming your start numbers are in col A and your end numbers are in
col B, you could use this formula:
=IF(A10,(B1-A1)/A1,(B1-A1)/(-1*A1))
On Wed, 23 Nov 2005 16:21:04 -0800, ?B?TmVpbCBS?=
wrote:
I am looking for a formula that tells me % of increase or decrease, The
problem is that some of my numbers are negitive eg. -147.80 has decreased to
-785.00 I am looking for the % to be a negitive only in this case
Thanks
Neil
|