[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Need help with a Maths Formula ?



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