Hi gma,

pls fill values on "?" as sample explanation for a quicker approach.

B5 C5 D5 E5 F5 G5
H5
Budget %savings Goal Target Actual Budget/Act Gain or -Loss
100 5.00% 95 5 95 5 100%
100 5.00% 95 5 98 ? ?%
100 5.00% 95 5 93 ? ?%
100 5.00% 95 5 105 ? ?%

regards

"gma" wrote:

Hi driller
i'm not explaining myself very well.
B5 C5 D5 E5 F5 G5
H5
Budget %savings Goal Target Actual Budget/Act Gain or -Loss
100 5.00% 95 5 95 5 100%
the way this works is: there is a budget number,B5 100, thats fixed or a
number we have set as the yearly budget ,and a goal
number,D5=abs((b5*c5)-b5), thats driven from the "% savings" C5 5%. the %
savings number is also fixed that we have set as a target savings of the
budget or in other words, we have a budget number but i'm asking that we also
try and beat the budget number by 5%, thus the target E5 =B5-D5 becomes the
number 5. the actual number is from the average of the quarter say 95. as the
actual number goes up i need G5 to increase or if the actual number decreases
i need G5 to decrease. Again not sure if i'm explaining myself very well.





"driller" wrote:

gma,

interpreting A1 as the index for your target f1, try with the following +/-
formula as fallows;

d1 = "input as-actual value"

Assumed as a respective input,
"When d1 is changed by either a smaller or larger value then i need e1 to
increase or decrease".
thus,
e1= (b1-d1)+c1
and where c1 is the goal for savings
f1=e1/c1 *100

so if actual/d1 = 98 ; then diff/e1 = 2 and gain/loss = 40.


--
regards,
driller

"gma" wrote:

i need to increase or decrease a cell. A1 is the consent value or base. B1 is
the goal which is a smaller value and d1 is the actual value. When d1 is
changed by either a smaller or larger value then i need e1 to increase or
decrease.
base goal savings actual diff gain/loss
A1 b1 c1 d1 e1 f1
100 95 5 95 5 100
fixed =a1-b1 moving =d1/a1 =e1/c1
if i change actual/d1 to say 98 i need the diff/e1 to increase or if i
change it to say 93 i need it to decrease. help!!