Need Help with IF/AND/OR Function

Hi Folks,

Can Anyone Help me with getting this fixed in Excel? I tried the variations mention below and many more but all are getting error in excel.

=IF(AND C2="LONG", IF(P2>J2,"WIN","LOSS"), OR(C2="SHORT", (P2<J2,"WIN","LOSS")

=IF(AND(C2="LONG", P2>J2,)"WIN", IF(C2="LONG", P2<J2,)"LOSS", IF(AND(C2="SHORT", P2<J2,)"WIN",IF(C2="LONG", P2>J2,)"LOSS"

=IF(C2="LONG", (P2>J2, "WIN", IF(C2="LONG", ( P2<J2, "LOSS", IF(C2="SHORT", (P2<J2, "WIN", IF(C2="SHORT", P2>J2, "LOSS")))))))

This is for my trading journal. Basically what I need is If I am taking a buy(LONG) position, it should be a win if P2>J2. Similarly for a Sell(SHORT) position it should be a win if P2<J2. C2 has the type of the position LONG/SHORT.

Would be very thankful for any help.

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

Attaching Sample Sheet

Attached sheet