S

#### sherlyn.moore

That is easy to do when both numbers are positive. But when one or the other, or both is negative, a simple division formula doesn't work. I created if statements that work for each of the three scenerios (neg/neg, pos/neg and neg/pos) but when I try to nest them into one very large if statement, instead of getting a percentage answer I get the answer of "false." Below are the four individual formulas and the nested formula. I would appreciateany help in figuring out where I am messing up.

Act/Bud= 14000/23000 ===> =A/B

Act/Bud= -14000/23000 ==> =IF(A<0,IF(B<0,ABS(A-B)/ABS(B),""))

Act/Bud= -14000/23000 ==> =IF(A<0,IF(B>0,-(B-A)/B),"")

Act/Bud= 14000/-23000 ==> =IF(A>0,IF(B<0,-(A-B)/B),"")

All of the above formulas give me the correct percentage difference; nesting them below I arrived at this:

=IF(A<0,IF(B<0,ABS(A-B)/ABS(B),IF(A<0,IF(B>0,-(B-A)/B),IF(A>0,IF(B<0,-(A-B)/B),A/B))))

Excel accepts this formula but gives me the answer of "False"