Your formula only takes into account 2 of 3 possible outcomes.
=IF(I19-E19>0,I19-E19,"")
1) Profit $74.01
2) if no sell price then insert a text value due to ""
3) Missing outcome is the ($3.49)
As always with excel, there are many ways to 'skin the cat' so to speak.
An option could be...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.