I have tried searching for this solution for ages without any luck yet.
Example:
In cell H1 I want the formula calculation to return F1-G1 "IF" E1 has "Buy" entered, OR H1 to return G1-F1 if E1 has "Sell" entered.
I am sure there is a way of doing this but have had to resort to this post.
Thanks in advance
Zeb
Bookmarks