Calculating correct pecentages with negative values

[Sue]

I need a formula that will return the correct percentage where there is 4
scenarios of comparing Actuals as a percentage of Plan. eg

Actual Plan
110 100
90 100
-10 100
-90 -100
-110 -100
50 -100
10 0
-10 0

I have tried several formulas but they do return the correct answer in all
cases.
Any suggestions would be appreciated. Many Thanks

 

[S Davis]

This is a bit confusing. What are you trying to do with that data? Do
you want the result on the right to appear if the result on the left is
input?

 

[pdberger]

Sue --

It would help to know what you think the correct percentages should be in
each case. So -- when you're expecting 0 and get 10, let's work backwards
from the answer you want. Same with expecting 100 and getting -10...

 

[Sue]

Hi

the answer will be the result of dividing the actual (column left) into the
Plan (column right) and be formatted to percentage. The simple formula of A/B
poses no problems when both values are positive but becomes complicated where
negative values are involved in either column.

 

[Dav]

you still have not said what you wish the answers to be, follow th
previous instructions

if a is +ve and b is +ve a/b a positive answer
if a is -ve and b is -ve what answer?
if a is +ve and b is -ve what answer?
if a is -ve and b is +ve what answer?

Regards

Da