Here goes:
A1 DATA INPUT CELL Budget Number "100"
B1 DATA INPUT CELL Target Savings % "5%"
C1 =ABS((A1*B1)-A1) Goal "95"
D1 =A1-C1 Savins Target "5"
E1 DATA INPUT CELL Actual "95"
F1 =A1-E1 Diff Budget/ Actual "5"
G1 =MIN(200%,F1/D1) Gain or Loss percentage "100%"

If the data inputed to cell E1 is lower then the "Actual" number then I need
G1's number to drop. If the number is higher, then I need to to increase.
Does this make sense?

"Shane Devenshire" wrote:

Hi,

What formulas do you currently have in place and what is the logic for each
calculations supposed to be?

I'm going to take a guess:

in G1 enter:

=E1/C1

maybe you have this as =C1/E1?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"gma" wrote:

A1 B1 C1 D1 E1 F1 G1
100 5.00% 95 5 95 5 100%
i need G1 to increase as E1 increases. the way it works now if E1 increases
then G1 decreases. the way the formula works is A1 is the base B1 is the
targeted percentage differance between A1 and C1. F1 is the gain or loss of
E1 and C1. So if E1 goes below C1 then I need G1 to decrease and if E1
increases then G1 needs to increase. Can someone help?