This is some random values I've inserted to check formula. Basically I want P/L to be TOTAL EXITED - TOTAL INVESTED However when I've not exited,P/L shows -(TOTAL INVESTED) as I'm using SUM(TOTAL EXITED,-TOTAL INVESTED). Any formula to check P/L only in cases I've TOTAL EXITED greater than 0.

Thanks..!

CodePudding user response：

Try an IF formula to check if TOTAL EXITED is greater than 0

=IF(TOTAL EXITED>0,TOTAL EXITED - TOTAL INVESTED, 0)