formula problem

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"
 

Attachments

  • Forum Help.xlsx
    16.1 KB · Views: 8
Pretty poor thread title - doesn't tell us anything about your problem. Next time, remember that pretty much EVERYBODY here has a formula problem! Imagine if all the aisles in the supermarket were labelled "Food" ...

Try this:

=IF(F6>1,IF(H6<G6,"Exercised","Closed"),"")
 
Hi thanks for the formula it's just what I needed, and I do apologise for the lack of thought for the thread heading
 
Try this in S6...=IF(AND(H6>G6,F6>1),"Closed","Exercise")
 
Onionsturtle - that does not account for cases where the date has yet to be entered.
 
Back
Top