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!!