If Formula resolution needed please.

[kgtrader]

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

[Estevaoba]

Please Login or Register  to view this content.

Good luck!

[kgtrader]

Thanks a lot Estevaoba, this helped although I did have to switch around the "Yes" and "No" as the formula was doing the opposite of what I needed.
Thanks for helping :-)

[Estevaoba]

You're welcome.
Sorry about the switching around. My bad.
Thanks for the feedback and the rep point added.