Pretty sure I am going about this the wrong way so need some help. I have a spreadsheet I used to track my stock options trades. There are some trades that I reach max profit on if it moves $5 away from my "anchor strike". So if it goes up $5.01 or $5000, I make the same amount. I am having trouble figuring out how to "cap" the max profit within the formula. The formula needs to read something like, "If F3-C3 is > $5, then $5". That part needs to be added to the existing formula in the cell which is currently:
=(SUM(ABS(F7-C7))*100*B7)-SUM(D7*B7)*100+E7
Make sense? How can I add it?
=(SUM(ABS(F7-C7))*100*B7)-SUM(D7*B7)*100+E7
Make sense? How can I add it?