| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Value if criteria met
I have a simple question, I believe.
I would like if H2 contains "Grapes", then enter "Grapes" in J2. If H2 contains "Oranges", then enter "Oranges in J2. If H2 does not contain Grapes or Oranges, enter "Neither" in J2. Can someone give me the formula for this? Thanks in advance. |
|
#2
|
|||
|
|||
|
=IF(H2="Grapes","Grapes",IF(H2="Oranges","Oranges" ,"Neither"))
"jh3016" wrote: I have a simple question, I believe. I would like if H2 contains "Grapes", then enter "Grapes" in J2. If H2 contains "Oranges", then enter "Oranges in J2. If H2 does not contain Grapes or Oranges, enter "Neither" in J2. Can someone give me the formula for this? Thanks in advance. |
|
#3
|
|||
|
|||
|
=IF(AND(H2<"Graapes",H2<"Oranges"),"Neither",H2)
-- HTH RP (remove nothere from the email address if mailing direct) "jh3016" wrote in message ... I have a simple question, I believe. I would like if H2 contains "Grapes", then enter "Grapes" in J2. If H2 contains "Oranges", then enter "Oranges in J2. If H2 does not contain Grapes or Oranges, enter "Neither" in J2. Can someone give me the formula for this? Thanks in advance. |
|
#4
|
|||
|
|||
|
Try...
=IF(H2="Grapes","Grapes",IF(H2="Oranges","Orange", "Neither")) Hope this helps! In article , jh3016 wrote: I have a simple question, I believe. I would like if H2 contains "Grapes", then enter "Grapes" in J2. If H2 contains "Oranges", then enter "Oranges in J2. If H2 does not contain Grapes or Oranges, enter "Neither" in J2. Can someone give me the formula for this? Thanks in advance. |
|
#5
|
|||
|
|||
|
Would help if I could spell
=IF(AND(H2<"Grapes",H2<"Oranges"),"Neither",H2) -- HTH RP (remove nothere from the email address if mailing direct) "Bob Phillips" wrote in message ... =IF(AND(H2<"Graapes",H2<"Oranges"),"Neither",H2) -- HTH RP (remove nothere from the email address if mailing direct) "jh3016" wrote in message ... I have a simple question, I believe. I would like if H2 contains "Grapes", then enter "Grapes" in J2. If H2 contains "Oranges", then enter "Oranges in J2. If H2 does not contain Grapes or Oranges, enter "Neither" in J2. Can someone give me the formula for this? Thanks in advance. |
|
#6
|
|||
|
|||
|
The formula works if H2 has "Grapes" or "Oranges" exactly. What I need is if
it CONTAINS "Grapes" or "Oranges". Thanks again. "Domenic" wrote: Try... =IF(H2="Grapes","Grapes",IF(H2="Oranges","Orange", "Neither")) Hope this helps! In article , jh3016 wrote: I have a simple question, I believe. I would like if H2 contains "Grapes", then enter "Grapes" in J2. If H2 contains "Oranges", then enter "Oranges in J2. If H2 does not contain Grapes or Oranges, enter "Neither" in J2. Can someone give me the formula for this? Thanks in advance. |
|
#7
|
|||
|
|||
|
Try the following instead...
=IF(OR(ISNUMBER(SEARCH({"Grapes","Oranges"},H2))), H2,"Neither") Hope this helps! In article , jh3016 wrote: The formula works if H2 has "Grapes" or "Oranges" exactly. What I need is if it CONTAINS "Grapes" or "Oranges". Thanks again. "Domenic" wrote: Try... =IF(H2="Grapes","Grapes",IF(H2="Oranges","Orange", "Neither")) Hope this helps! In article , jh3016 wrote: I have a simple question, I believe. I would like if H2 contains "Grapes", then enter "Grapes" in J2. If H2 contains "Oranges", then enter "Oranges in J2. If H2 does not contain Grapes or Oranges, enter "Neither" in J2. Can someone give me the formula for this? Thanks in advance. |
|
#8
|
|||
|
|||
|
Sorry, make that...
=IF(ISNUMBER(SEARCH("Grapes",H2)),"Grapes",IF(ISNU MBER(SEARCH("Oranges",H 2)),"Oranges","Neither")) Hope this helps! In article , Domenic wrote: Try the following instead... =IF(OR(ISNUMBER(SEARCH({"Grapes","Oranges"},H2))), H2,"Neither") Hope this helps! |
|
#9
|
|||
|
|||
|
I get an error when I run this.
"Domenic" wrote: Sorry, make that... =IF(ISNUMBER(SEARCH("Grapes",H2)),"Grapes",IF(ISNU MBER(SEARCH("Oranges",H 2)),"Oranges","Neither")) Hope this helps! In article , Domenic wrote: Try the following instead... =IF(OR(ISNUMBER(SEARCH({"Grapes","Oranges"},H2))), H2,"Neither") Hope this helps! |
|
#10
|
|||
|
|||
|
If you copied and pasted the formula into your spreadsheet, make sure a
line break hasn't been added. Does this help? In article , jh3016 wrote: I get an error when I run this. "Domenic" wrote: Sorry, make that... =IF(ISNUMBER(SEARCH("Grapes",H2)),"Grapes",IF(ISNU MBER(SEARCH("Oranges",H 2)),"Oranges","Neither")) Hope this helps! In article , Domenic wrote: Try the following instead... =IF(OR(ISNUMBER(SEARCH({"Grapes","Oranges"},H2))), H2,"Neither") Hope this helps! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find largest alphanumeric value matching alpha criteria in databas | Excel Worksheet Functions | |||
| sorting more than 3 keys | Excel Discussion (Misc queries) | |||
| Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
| Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Linear Mode
