Formula help

[markster]

Hi there

Just need a bit of help with a formula. Basically use the following formula which is pretty straightforward:

=IF(I7<0,"OPEN","CLOSED")

But I need to add a further variable to add to the above formula that totally ignores the first bit of the formula and returns "Pending Stop" if cell C7 contains the term Sell Stop or Buy Stop

So if I7 <0 and cell C7 does not contain the words Sell Stop or Buy Stop it returns Open
So if I7 <0 and cell C7 does not contain the words Sell Stop or Buy Stop it returns Close

In the above scenarios if the cell C7 contains either Sell Stop or Buy Stop it returns Pending Order

Hope this is clear.

Thanks in advance.
Mark

 

[kweaver]

Unclear as these two lines are the same test:

So if I7 <0 and cell C7 does not contain the words Sell Stop or Buy Stop it returns Open
So if I7 <0 and cell C7 does not contain the words Sell Stop or Buy Stop it returns Close

 

[markster]

Unclear as these two lines are the same test:

So if I7 <0 and cell C7 does not contain the words Sell Stop or Buy Stop it returns Open
So if I7 <0 and cell C7 does not contain the words Sell Stop or Buy Stop it returns Close

Sorry the second one should be if I7>0 and Cell C7 does not contain the words Sell Stop or Buy Stop it returns Close

 

[kweaver]

Is this what you mean?

=IF(AND(I7<0,OR(C7<>"Sell Stop",C7<>"Buy Stop")),"Open","Close")

 

[markster]

Hi thanks for this - not quite. If C7 contains "Buy Stop" or "Sell Stop" it should override the other criteria and return "Pending Order" not "Open or Close"
Thanks again.
Mark

 

[markster]

Hi there again - any ideas? Just tried to amend the formula myself and just get an error.
Thanks again
Mark