I am trying to enter an equation in excel to help compare two percentages BETWEEN TWO GROUPS - a control group and an experimental group that are either (-) negative (aka saved money, because costs at the the end of year are LOWER) or LOST money (+) positive value(aka because costs at the end of the year are HIGHER). I have shown a few numbers and values just as an example.
In this example:
Control Group = A
Experimental Group = B
Here is what i am trying to input:
Value
++ Cost increase
A>B: A and B lost money, but A lost more money than B, subtract B-A *-1= -8% savings
A<B: A and B lost money, but B lost more money than A, subtract B-A = +8% loss
Mix Cost increase and decrease
+- A>B: A lost money and B saved money, add ABS[10:2] *-1 (-12%) savings (note excel wont let me do ABS since this is a %)
-+ A<B: A saved money and B lost money, add ABS[10:2] (+12%) loss
-- Decrease in costs
A>B: A and B saved money, but A saved more money than B, = B i.e. -2% (keep at -2%)
A<B: A and B saved money, but B saved more money than A, B-A = - 8% savings
PLEASE HELP. EXAMPLE WORK BOOK ATTACHED
Bookmarks