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

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?

Sue wrote:
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

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.

"S Davis" wrote:

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?

Sue wrote:
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

you still have not said what you wish the answers to be, follow the
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

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=563862

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" wrote:

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