| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with solving this if statement which uses a search for text s
Hi
I am using Excel 2007 and trying to fix this formula. In exvcel, there are several questions which could be used in the result of the same cell. This is what I need fixed: =IF(OR(ISNUMBER(SEARCH("go",YS!E13)),(ISNUMBER(SEA RCH("D",YS!E14)),(ISNUMBER(SEARCH("F",YS!E14)))))) ,"Yes","Apple") What I'm trying to do is put multiple conditions on this cell.YS!E13 contains the word "GO", or YS contains either a "D" or "F", then the cell should return "YES", if not, it should return "Apple". I can't get this formula to work with this complex equation. Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with solving this if statement which uses a search for text s
Try the below
=IF(COUNT(SEARCH("GO",YS!E13),SEARCH("D",YS!E13),S EARCH("F",YS!E13)),"Yes","Apple") If this post helps click Yes --------------- Jacob Skaria "forest8" wrote: Hi I am using Excel 2007 and trying to fix this formula. In exvcel, there are several questions which could be used in the result of the same cell. This is what I need fixed: =IF(OR(ISNUMBER(SEARCH("go",YS!E13)),(ISNUMBER(SEA RCH("D",YS!E14)),(ISNUMBER(SEARCH("F",YS!E14)))))) ,"Yes","Apple") What I'm trying to do is put multiple conditions on this cell.YS!E13 contains the word "GO", or YS contains either a "D" or "F", then the cell should return "YES", if not, it should return "Apple". I can't get this formula to work with this complex equation. Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with solving this if statement which uses a search for text s
multiple conditions on this cell.YS!E13
=IF(OR(ISNUMBER(SEARCH("go",YS!E13)),(ISNUMBER(SEA RCH("D",YS!E14)),(ISNUMBER(SEARCH("F",YS!E14)))))) ,"Yes","Apple") Your formula is referencing 2 cells, E13 and E14. Try it like this: =IF(COUNT(SEARCH({"go","D","F"},YS!E13)),"Yes","Ap ple") -- Biff Microsoft Excel MVP "forest8" wrote in message ... Hi I am using Excel 2007 and trying to fix this formula. In exvcel, there are several questions which could be used in the result of the same cell. This is what I need fixed: =IF(OR(ISNUMBER(SEARCH("go",YS!E13)),(ISNUMBER(SEA RCH("D",YS!E14)),(ISNUMBER(SEARCH("F",YS!E14)))))) ,"Yes","Apple") What I'm trying to do is put multiple conditions on this cell.YS!E13 contains the word "GO", or YS contains either a "D" or "F", then the cell should return "YES", if not, it should return "Apple". I can't get this formula to work with this complex equation. Thank you |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with solving this if statement which uses a search for te
Forgot to mention that when you are searching multiple cells...you need to
have mutiple SEARCH conditions within COUNT..for E13, E14 etc;.... =IF(COUNT(SEARCH("GO",YS!E13),SEARCH("D",YS!E14),S EARCH("F",YS!E14)),"Yes","Apple") If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Try the below =IF(COUNT(SEARCH("GO",YS!E13),SEARCH("D",YS!E13),S EARCH("F",YS!E13)),"Yes","Apple") If this post helps click Yes --------------- Jacob Skaria "forest8" wrote: Hi I am using Excel 2007 and trying to fix this formula. In exvcel, there are several questions which could be used in the result of the same cell. This is what I need fixed: =IF(OR(ISNUMBER(SEARCH("go",YS!E13)),(ISNUMBER(SEA RCH("D",YS!E14)),(ISNUMBER(SEARCH("F",YS!E14)))))) ,"Yes","Apple") What I'm trying to do is put multiple conditions on this cell.YS!E13 contains the word "GO", or YS contains either a "D" or "F", then the cell should return "YES", if not, it should return "Apple". I can't get this formula to work with this complex equation. Thank you |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with solving this if statement which uses a search for te
Forgot to mention that when you are searching
multiple cells...you need to have mutiple SEARCH conditions within COUNT..for E13, E14 etc;.... =IF(COUNT(SEARCH("GO",YS!E13),SEARCH("D",YS!E14), SEARCH("F",YS!E14)),"Yes","Apple") Array entered** : =IF(COUNT(SEARCH({"GO","D","F"},YS!E13:E14)),"Yes" ,"Apple") ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. -- Biff Microsoft Excel MVP "Jacob Skaria" wrote in message ... Forgot to mention that when you are searching multiple cells...you need to have mutiple SEARCH conditions within COUNT..for E13, E14 etc;.... =IF(COUNT(SEARCH("GO",YS!E13),SEARCH("D",YS!E14),S EARCH("F",YS!E14)),"Yes","Apple") If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Try the below =IF(COUNT(SEARCH("GO",YS!E13),SEARCH("D",YS!E13),S EARCH("F",YS!E13)),"Yes","Apple") If this post helps click Yes --------------- Jacob Skaria "forest8" wrote: Hi I am using Excel 2007 and trying to fix this formula. In exvcel, there are several questions which could be used in the result of the same cell. This is what I need fixed: =IF(OR(ISNUMBER(SEARCH("go",YS!E13)),(ISNUMBER(SEA RCH("D",YS!E14)),(ISNUMBER(SEARCH("F",YS!E14)))))) ,"Yes","Apple") What I'm trying to do is put multiple conditions on this cell.YS!E13 contains the word "GO", or YS contains either a "D" or "F", then the cell should return "YES", if not, it should return "Apple". I can't get this formula to work with this complex equation. Thank you |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with solving this if statement which uses a search for te
What about? (non-array entered)
=IF(COUNT(SEARCH({"GO","D","F"},E13&E14)),"Yes","A pple") If this post helps click Yes --------------- Jacob Skaria "T. Valko" wrote: Forgot to mention that when you are searching multiple cells...you need to have mutiple SEARCH conditions within COUNT..for E13, E14 etc;.... =IF(COUNT(SEARCH("GO",YS!E13),SEARCH("D",YS!E14), SEARCH("F",YS!E14)),"Yes","Apple") Array entered** : =IF(COUNT(SEARCH({"GO","D","F"},YS!E13:E14)),"Yes" ,"Apple") ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. -- Biff Microsoft Excel MVP "Jacob Skaria" wrote in message ... Forgot to mention that when you are searching multiple cells...you need to have mutiple SEARCH conditions within COUNT..for E13, E14 etc;.... =IF(COUNT(SEARCH("GO",YS!E13),SEARCH("D",YS!E14),S EARCH("F",YS!E14)),"Yes","Apple") If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Try the below =IF(COUNT(SEARCH("GO",YS!E13),SEARCH("D",YS!E13),S EARCH("F",YS!E13)),"Yes","Apple") If this post helps click Yes --------------- Jacob Skaria "forest8" wrote: Hi I am using Excel 2007 and trying to fix this formula. In exvcel, there are several questions which could be used in the result of the same cell. This is what I need fixed: =IF(OR(ISNUMBER(SEARCH("go",YS!E13)),(ISNUMBER(SEA RCH("D",YS!E14)),(ISNUMBER(SEARCH("F",YS!E14)))))) ,"Yes","Apple") What I'm trying to do is put multiple conditions on this cell.YS!E13 contains the word "GO", or YS contains either a "D" or "F", then the cell should return "YES", if not, it should return "Apple". I can't get this formula to work with this complex equation. Thank you |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with solving this if statement which uses a search for te
What about? (non-array entered)
=IF(COUNT(SEARCH({"GO","D","F"},E13&E14)),"Yes"," Apple") Yeah, that's a possibility. It depends on the data. What would happen if this was the data: E13 = G E14 = O -- Biff Microsoft Excel MVP "Jacob Skaria" wrote in message ... What about? (non-array entered) =IF(COUNT(SEARCH({"GO","D","F"},E13&E14)),"Yes","A pple") If this post helps click Yes --------------- Jacob Skaria "T. Valko" wrote: Forgot to mention that when you are searching multiple cells...you need to have mutiple SEARCH conditions within COUNT..for E13, E14 etc;.... =IF(COUNT(SEARCH("GO",YS!E13),SEARCH("D",YS!E14), SEARCH("F",YS!E14)),"Yes","Apple") Array entered** : =IF(COUNT(SEARCH({"GO","D","F"},YS!E13:E14)),"Yes" ,"Apple") ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. -- Biff Microsoft Excel MVP "Jacob Skaria" wrote in message ... Forgot to mention that when you are searching multiple cells...you need to have mutiple SEARCH conditions within COUNT..for E13, E14 etc;.... =IF(COUNT(SEARCH("GO",YS!E13),SEARCH("D",YS!E14),S EARCH("F",YS!E14)),"Yes","Apple") If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Try the below =IF(COUNT(SEARCH("GO",YS!E13),SEARCH("D",YS!E13),S EARCH("F",YS!E13)),"Yes","Apple") If this post helps click Yes --------------- Jacob Skaria "forest8" wrote: Hi I am using Excel 2007 and trying to fix this formula. In exvcel, there are several questions which could be used in the result of the same cell. This is what I need fixed: =IF(OR(ISNUMBER(SEARCH("go",YS!E13)),(ISNUMBER(SEA RCH("D",YS!E14)),(ISNUMBER(SEARCH("F",YS!E14)))))) ,"Yes","Apple") What I'm trying to do is put multiple conditions on this cell.YS!E13 contains the word "GO", or YS contains either a "D" or "F", then the cell should return "YES", if not, it should return "Apple". I can't get this formula to work with this complex equation. Thank you |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with solving this if statement which uses a search for te
True..That depends on the data..Thanks Biff. The point here is that for
multiple range of cells we can use the array entered formula "T. Valko" wrote: What about? (non-array entered) =IF(COUNT(SEARCH({"GO","D","F"},E13&E14)),"Yes"," Apple") Yeah, that's a possibility. It depends on the data. What would happen if this was the data: E13 = G E14 = O -- Biff Microsoft Excel MVP "Jacob Skaria" wrote in message ... What about? (non-array entered) =IF(COUNT(SEARCH({"GO","D","F"},E13&E14)),"Yes","A pple") If this post helps click Yes --------------- Jacob Skaria "T. Valko" wrote: Forgot to mention that when you are searching multiple cells...you need to have mutiple SEARCH conditions within COUNT..for E13, E14 etc;.... =IF(COUNT(SEARCH("GO",YS!E13),SEARCH("D",YS!E14), SEARCH("F",YS!E14)),"Yes","Apple") Array entered** : =IF(COUNT(SEARCH({"GO","D","F"},YS!E13:E14)),"Yes" ,"Apple") ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. -- Biff Microsoft Excel MVP "Jacob Skaria" wrote in message ... Forgot to mention that when you are searching multiple cells...you need to have mutiple SEARCH conditions within COUNT..for E13, E14 etc;.... =IF(COUNT(SEARCH("GO",YS!E13),SEARCH("D",YS!E14),S EARCH("F",YS!E14)),"Yes","Apple") If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Try the below =IF(COUNT(SEARCH("GO",YS!E13),SEARCH("D",YS!E13),S EARCH("F",YS!E13)),"Yes","Apple") If this post helps click Yes --------------- Jacob Skaria "forest8" wrote: Hi I am using Excel 2007 and trying to fix this formula. In exvcel, there are several questions which could be used in the result of the same cell. This is what I need fixed: =IF(OR(ISNUMBER(SEARCH("go",YS!E13)),(ISNUMBER(SEA RCH("D",YS!E14)),(ISNUMBER(SEARCH("F",YS!E14)))))) ,"Yes","Apple") What I'm trying to do is put multiple conditions on this cell.YS!E13 contains the word "GO", or YS contains either a "D" or "F", then the cell should return "YES", if not, it should return "Apple". I can't get this formula to work with this complex equation. Thank you |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with solving this if statement which uses a search for te
No, the point here is that I'm messing with you! <g
If you don't want to use an array formula, and since we don't know what the possible cell entries could be, something like this should be fairly safe: =IF(COUNT(SEARCH({"GO","D","F"},E13&"^^"&E14)),"Ye s","Apple") -- Biff Microsoft Excel MVP "Jacob Skaria" wrote in message ... True..That depends on the data..Thanks Biff. The point here is that for multiple range of cells we can use the array entered formula "T. Valko" wrote: What about? (non-array entered) =IF(COUNT(SEARCH({"GO","D","F"},E13&E14)),"Yes"," Apple") Yeah, that's a possibility. It depends on the data. What would happen if this was the data: E13 = G E14 = O -- Biff Microsoft Excel MVP "Jacob Skaria" wrote in message ... What about? (non-array entered) =IF(COUNT(SEARCH({"GO","D","F"},E13&E14)),"Yes","A pple") If this post helps click Yes --------------- Jacob Skaria "T. Valko" wrote: Forgot to mention that when you are searching multiple cells...you need to have mutiple SEARCH conditions within COUNT..for E13, E14 etc;.... =IF(COUNT(SEARCH("GO",YS!E13),SEARCH("D",YS!E14), SEARCH("F",YS!E14)),"Yes","Apple") Array entered** : =IF(COUNT(SEARCH({"GO","D","F"},YS!E13:E14)),"Yes" ,"Apple") ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. -- Biff Microsoft Excel MVP "Jacob Skaria" wrote in message ... Forgot to mention that when you are searching multiple cells...you need to have mutiple SEARCH conditions within COUNT..for E13, E14 etc;.... =IF(COUNT(SEARCH("GO",YS!E13),SEARCH("D",YS!E14),S EARCH("F",YS!E14)),"Yes","Apple") If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Try the below =IF(COUNT(SEARCH("GO",YS!E13),SEARCH("D",YS!E13),S EARCH("F",YS!E13)),"Yes","Apple") If this post helps click Yes --------------- Jacob Skaria "forest8" wrote: Hi I am using Excel 2007 and trying to fix this formula. In exvcel, there are several questions which could be used in the result of the same cell. This is what I need fixed: =IF(OR(ISNUMBER(SEARCH("go",YS!E13)),(ISNUMBER(SEA RCH("D",YS!E14)),(ISNUMBER(SEARCH("F",YS!E14)))))) ,"Yes","Apple") What I'm trying to do is put multiple conditions on this cell.YS!E13 contains the word "GO", or YS contains either a "D" or "F", then the cell should return "YES", if not, it should return "Apple". I can't get this formula to work with this complex equation. Thank you |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with solving this if statement which uses a search for te
These responses were extremely helpful. And they both are viable in my
spreadhseet. In answer to the posts re multiple cell references, my original equation references four different cells. "Jacob Skaria" wrote: Try the below =IF(COUNT(SEARCH("GO",YS!E13),SEARCH("D",YS!E13),S EARCH("F",YS!E13)),"Yes","Apple") If this post helps click Yes --------------- Jacob Skaria "forest8" wrote: Hi I am using Excel 2007 and trying to fix this formula. In exvcel, there are several questions which could be used in the result of the same cell. This is what I need fixed: =IF(OR(ISNUMBER(SEARCH("go",YS!E13)),(ISNUMBER(SEA RCH("D",YS!E14)),(ISNUMBER(SEARCH("F",YS!E14)))))) ,"Yes","Apple") What I'm trying to do is put multiple conditions on this cell.YS!E13 contains the word "GO", or YS contains either a "D" or "F", then the cell should return "YES", if not, it should return "Apple". I can't get this formula to work with this complex equation. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested formula to search a text string and return specific text | Excel Worksheet Functions | |||
| Fun with text functions - search for text | Excel Worksheet Functions | |||
| Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
| If then statement to search for text possible? | Excel Discussion (Misc queries) | |||
| Search for a specific character in a cell in an if statement | Excel Worksheet Functions | |||
Linear Mode
