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