Hi Just need a quick help working out this formula.
The formula is for column C in the attached workbook:
If column E is 'Long' and Entry Price (column A) is above Current Price (column D) then Triggered (column C) should say 'Yes'.
If column E is 'Short' and Entry Price (column A) is below Current Price (column D) then Triggered (column C) should say 'Yes'.
If column E is 'Long' and Entry Price (column A) is below Current Price (column D) then Triggered (column C) should say 'No'.
If column E is 'Short' and Entry Price (column A) is above Current Price (column D) then Triggered (column C) should say 'No'.
Thanks
Bookmarks