Thread: Modify Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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.