Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modify a formula? | Excel Discussion (Misc queries) | |||
Modify a Formula | Excel Worksheet Functions | |||
Modify A Formula | Excel Worksheet Functions | |||
Modify A formula | Excel Worksheet Functions | |||
Modify a formula | Excel Discussion (Misc queries) |