PureBytes Links
Trading Reference Links
|
Hi,
I am sure this is very basic maths but I cannot get to the solution and now
I am totally confused.
Could anybody help and give me the solution?
Columns :
A = Base Number
B = Level
C = First factor
D = Percent base
E = Percent base level
F = Percent base increase factor
G = Percent applicable
H = Target number UP
I = target number Down
Column Formulas =
G = D*(1+(E*F))
H = A*((1+C)+(B*G)))
I = A*((1-C)-(B*G)))
A B C D E F G H I
1 5000 1 0.05 0.020 0 0.10 0.020 5350 4650
2 5000 2 0.05 0.020 1 0.10 0.022 5470 4530
3 5000 3 0.05 0.020 2 0.10 0.024 5610 4390
4 5000 4 0.05 0.020 3 0.10 0.026 5770 4230
My Question is :
>From H3 and I3, what is the math formula for finding back the H2 or I2
number USING ONLY ANY NUMBERS ON ROW 3
Other said : What is the formula to get back to 5470 form 5610 or to 4530
from 4390 using only the inputs (5000; 3; 0,05; 0,020; 2; 0,10; 0,024;
5610 or 4390)
Thanks for any kind help.
Regards
Philippe
|