Hi,

My problem:

Column (G) Column (H) Column (I) (**THIS LINE AND LINE BELOW NEED TO BE PLACED ABOVE THE NUMBERS. THEY ARE IN CORRECT ORDER BUT I CANNOT MOVE THEM ALONG!**)

Stop Loss Take Profits Open Price [TABLE="width: 585"]

Row 1 Sell

[/td]

[TD="align: right"][/TD]

[TD="align: right"]**1.24765**[/TD]

[TD="align: right"]**1.23853**[/TD]

[TD="align: right"]**1.24423**[/TD]

Row 2 Buy

[/td]

[TD="align: right"][/TD]

[TD="align: right"]**79.482**[/TD]

[TD="align: right"]**80.000**[/TD]

[TD="align: right"]**79.741**[/TD]

[/TABLE]

What im trying to do is doing simple subtraction between the "**OPEN PRICE** - **TAKE PROFITS**" and then "**OPEN PRICE** - **STOP LOSS**". This is really straight forward, I know, BUT, when im doing the formula its shown as a minus number or positive because it isnt factoring in that one is a BUY price and the OTHER is a SELL price meaning the subtraction needs to be reversed on BUY prices.

Below is an example just looking at "OPEN PRICE - TAKE PROFITS" BUT doesnt factor in that I also need the ANSWER to be expressed to different decimal places. Below will explain what it is I am looking for.

=(I2-H2) = -0.259 = **25.9 POINTS**

=(I1-H1) = 0.00570 =** 57.0 POINTS**

The outcome that **SHOULD** be read = **82.9 POINTS**

there are will only ever be two price formats to two different decimal places found within the table and i`ll try and show why I have the answer as **82.9**

00.000 (3 decimal places)

0.00000 (5 decimal places)

With this said, the numbers that are expressed in 3 decimal places (00.000) to me are are then broken down further and represented as POINTS. For example:

00.000 + 00.555 = **55.5** POINTS

00.000 + 01.555 = **155.5** POINTS

00.000 + 10.555 = **1055.5** POINTS

The number will __never__ be expressed "000.000"

The other decimal place number is to 5 decimal places, examples are seen below how the points are recorded:

0.00000 + 0.00005 = **0.5 **POINTS

0.00000 + 0.00055 = **5.5** POINTS

0.00000 + 0.00555 = **55.5** POINTS

0.00000 + 0.05555 = **555.5** POINTS

Everything above is simply looking at "OPEN PRICE - TAKE PROFITS" = expressed as points to relevant decimal places

The rules above also need to be applied to "OPEN PRICE - STOP LOSS" = expressed as points to relevant decimal places

I am looking for two formula basically and would be incredibly grateful for anyone's help!