xeven_
Active Member
- Joined
- Jan 20, 2012
- Messages
- 302
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.
<tbody>
</tbody>
MARKET | PIP VALUE | BID RATE | REQUIRED MARGIN | LEVERAGE | CONTRACT SIZE | |
AUD/USD | 0.1 | 0.7047 | 21.14 | 33.33:1 | 1000 | |
|
<tbody>
</tbody>