Modify Formula
 

I am trying to modify this formula

=IF(IF(J5883="Buy";L5883-O5883;N5883-L5883)=0;"Yes";"No")

to include this expression:

if m5883 contains "Market" return "Yes"

Thank you in advance.

Modify Formula
 

Try this:

=IF(ISNUMBER(SEARCH("market";M5883));"Yes";IF(IF(J 5883="Buy";L5883-
O5883;N5883-L5883)=0;"Yes";"No"))

Hope this helps.

Pete

On Nov 26, 5:15*pm, carl wrote:
I am trying to modify this formula

=IF(IF(J5883="Buy";L5883-O5883;N5883-L5883)=0;"Yes";"No")

to include this expression:

if m5883 contains "Market" return "Yes"

Thank you in advance.

Modify Formula
 

Hi,

What exactly do you want your formula to calculate - is J5883= "Market"
going to be tested for the condition or is it a separate condition
altogether?

=IF(IF(OR(J1="Buy",J1="Market"),L1-O1,N1-L1)=0,"Yes","No")
or
=IF(OR(J1="Market",IF(J1="Buy",L1-O1,N1-L1)=0),"Yes","No")

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"carl" wrote:

I am trying to modify this formula

=IF(IF(J5883="Buy";L5883-O5883;N5883-L5883)=0;"Yes";"No")

to include this expression:

if m5883 contains "Market" return "Yes"

Thank you in advance.