I can make my formula work to get the percentages,But I can not get it to
work if A is positive and B is negative with the percentage given as a
percent of positive increase. ie column a 29 column b -1900 my formula
gives a 15% improvement instead of 115%. So what I need is a formula that
will give me
negative to positive with a positive percentage, and a within this formula
negative to negative and positive to negative.


thanks for the help
enjoy your day
gail


"Gail" wrote:

I have been trying to create an IF statement that gives a percentage as the
answer.
I need the percentage of change of A compared to B
-I can create the statement if column A is Positive and Column B is Positive
or if A is negative and B is positive but I can not get the statement to
work if A is positive and B is negative.
this is the formula I am using IF(B1<0,+A1/-B1,A1/B1)

I have just not been able to add the next formula to make this work.
Can any one help?

thanks for the help
enjoy your day
gail