Modify Formula

[carl]

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.

 

[Pete_UK]

Try this:

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

Hope this helps.

Pete

 

[Shane Devenshire]

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