There is no rule there that you can apply that I can see. You take different
actions in different cases without any rule that I can see, and I don't get
the same answers as you in the formulae you use.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Eddy" wrote in message
...
Rule is the difference of POR and ACT divide by POR. I thought of 5
different formulas to cater each scenario. Easy way out is build mega
formula
with IF condition. If this a better way of doing this???

=(ABS(D3)+ABS(D4))/ABS(D3)-1 (61% for first pair)
=-(ABS(E3)+ABS(E4))/ABS(E3)-1 (-222%)
=-(ABS(F3)+ABS(F4))/F3+1 (231%)
=(ABS(G3)+ABS(G4))/ABS(G3)-1 (22%)
=-(ABS(H3)+ABS(H4))/ABS(H3)+1 (-186%)


POR 591 107 (160) (559) (159)
ACT 362 (24) 50 (121) (295)
% perf 61% -222% 231% 22% -186%


Eddy

"Bob Phillips" wrote:

So assuming it isn't a simple case of (24)/107, what is your calculation
rule.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Eddy" wrote in message
...
Yes, brackets are negatives. I expect single ratio for each pair of
data,
like my example. The tricky part is with the negatives.

"Bob Phillips" wrote:

What does the brackets indicate (negatives)? What answer do you expect
from
this, a single ratio of the sums, multiple ratios,...?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Eddy" wrote in message
...
I need to measure one set of data over the other. For example, Set A
is
forecast and Set B is actuals.
Set A 591 107 (160) (559) (159)
Set B 362 (24) 50 (121) (295)

First pair of data is simple. 362/591= 61%. This means acutals is
61%
to
fcst.

Is there a formula to cater to all scenarios above?