Calculate D in G when F is changed ?

[xeven_]

The value in column F is 1000. The value in column D is 21.14. Each time I increase the value in F by 1000 the value in D should also double, E.G. – F = 2000 then D = 42.28 and so on. Is there a formula I can place in column G that will calculate the base amount in column D each time I change or increase the value in F by 1000? That is, when I put 2000 in F, I want the doubled or tripled value of D to appear in G.

MARKET	PIP VALUE	BID RATE	REQUIRED MARGIN	LEVERAGE	CONTRACT SIZE
AUD/USD	0.1	0.7047	21.14	33.33:1	1000

<tbody>
</tbody>

 

[Fluff]

How about
=D2*INT(F2/1000)

 

[Eric W]

Try:

=MAX(1,INT(F2/1000))*D2

This will give a minimum value of 21.14 no matter what's in F. It also only calculates at the 1000 boundaries, you can remove the INT() function if you want a continuous function.

 

[xeven_]

Both of those formulas works perfectly thank ya'll !!!!!!!!!!!!!!!!

 

[Eric W]

Glad we could help!