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.

[TABLE="width: 617"]
<tbody>[TR]
[TD]MARKET
[/TD]
[TD]PIP VALUE
[/TD]
[TD]BID RATE
[/TD]
[TD]REQUIRED MARGIN
[/TD]
[TD]LEVERAGE
[/TD]
[TD] CONTRACT SIZE
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]AUD/USD
[/TD]
[TD] 0.1
[/TD]
[TD]0.7047
[/TD]
[TD]21.14
[/TD]
[TD]33.33:1
[/TD]
[TD]1000

[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]

 

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