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.
|