As in image above : i am trying to make a formula for column J and K:

- As in column "J" i need the

**Pips In Lose**to be calculated in case i type "L" in column "I"

- As in column "K" i need the

**Pips in Profit**to be calculated in case i type "P" in column "I"

- In column "I" when i type

**BEP**(Break Even Point) it should give 0 in both "J" and "K"

So, To calculate the

**Pips In Lose**and

**Pips In Profit**you have to check the following first:

1 - Check if the deal is (

**Buy/Buy Limit**)

__SAME JOB__Or (

**Sell/Sell Limit**)

__SAME JOB__"But Mist type the 4 types in formula"

2- The

**Price format**for example

**EUR/USD**is x.xxxx e.g

*, and*

**1.1600****EUR/JPY**is xxx.xx e.g

*and*

**129.00**,**Oil**is xx.xx e.g

*how to calculate*

**72.00.**

I THINK FOR (1 AND 2) ABOVE, NEEDS TO USE NESTED IF , AND I DON'T KNOW HOW LOL

NowI THINK FOR (1 AND 2) ABOVE, NEEDS TO USE NESTED IF , AND I DON'T KNOW HOW LOL

Now

**Pips In Lose**and

**Pips In Profit ..**

Pips In Profit =

__* IN case the position is Buy Or Buy Limit :__

Pips In Profit =

**Take Profit - Entry Point.**

**Pips In Lose**

**= Entry Point - Stope Lose (result must be in**

**minus.**

**)**

* In case the position is Sell or Sell Limit :

Pips In Profit = Entry Point - Take Profit.

Pips In Lose = Stope Lose - Entry Point (result must be in minus.)

Hope you help me with the formula to contains all the above cases ,

My Regards.

* In case the position is Sell or Sell Limit :

Pips In Profit = Entry Point - Take Profit.

Pips In Lose = Stope Lose - Entry Point (result must be in minus.)

Hope you help me with the formula to contains all the above cases ,

My Regards.