willmac
New member
- Joined
- May 28, 2019
- Messages
- 3
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2007 .xlsm
Hi can someone help with a formula for an options trading spreadsheet that I have made up.
Works fine but I need to add another part to it.
Once I enter a closing date in cell F6 a notice will come up in cell S6 "Closed" formula is simply =IF(F6>1,"Closed",)
What I now need is to add into that formula that if I still enter the close date but H6 is less than G6 then S6 will enter "Exercised"
Works fine but I need to add another part to it.
Once I enter a closing date in cell F6 a notice will come up in cell S6 "Closed" formula is simply =IF(F6>1,"Closed",)
What I now need is to add into that formula that if I still enter the close date but H6 is less than G6 then S6 will enter "Exercised"