Home |
Search |
Today's Posts |
#1
|
|||
|
|||
if statement based on "starts with "
Can you build an if statement in excel that is driven by "starts with"
I have a filed that contains several text statements defining service level. I have 3 that start with "Next Day" & end with "Drive" "Over night AM" "Over night PM" I want the cel with the if statement to say soemthing simple like if it starts with Next Day place a 1 here, etc. Is there such a thing as starts with or contains in excel Thanks for your time |
#2
|
|||
|
|||
if statement based on "starts with "
=ISNUMBER(MATCH("Next Day*",A2))+0
Todd F. wrote: Can you build an if statement in excel that is driven by "starts with" I have a filed that contains several text statements defining service level. I have 3 that start with "Next Day" & end with "Drive" "Over night AM" "Over night PM" I want the cel with the if statement to say soemthing simple like if it starts with Next Day place a 1 here, etc. Is there such a thing as starts with or contains in excel Thanks for your time |
#3
|
|||
|
|||
if statement based on "starts with "
thanks but does not help
"Aladin Akyurek" wrote: =ISNUMBER(MATCH("Next Day*",A2))+0 Todd F. wrote: Can you build an if statement in excel that is driven by "starts with" I have a filed that contains several text statements defining service level. I have 3 that start with "Next Day" & end with "Drive" "Over night AM" "Over night PM" I want the cel with the if statement to say soemthing simple like if it starts with Next Day place a 1 here, etc. Is there such a thing as starts with or contains in excel Thanks for your time |
#4
|
|||
|
|||
if statement based on "starts with "
Why not?
If A2 houses "Next Day all will be on Drive"... =ISNUMBER(MATCH("Next Day*",A2))+0 would return 1. Todd F. wrote: thanks but does not help "Aladin Akyurek" wrote: =ISNUMBER(MATCH("Next Day*",A2))+0 Todd F. wrote: Can you build an if statement in excel that is driven by "starts with" I have a filed that contains several text statements defining service level. I have 3 that start with "Next Day" & end with "Drive" "Over night AM" "Over night PM" I want the cel with the if statement to say soemthing simple like if it starts with Next Day place a 1 here, etc. Is there such a thing as starts with or contains in excel Thanks for your time -- [1] The SumProduct function should implicitly coerce the truth values to their Excel numeric equivalents. [2] The lookup functions should have an optional argument for the return value, defaulting to #N/A in its absence. |
#5
|
|||
|
|||
if statement based on "starts with "
thanks so you are using the isnumber to read a iece of text - the is number
threw me. "Aladin Akyurek" wrote: Why not? If A2 houses "Next Day all will be on Drive"... =ISNUMBER(MATCH("Next Day*",A2))+0 would return 1. Todd F. wrote: thanks but does not help "Aladin Akyurek" wrote: =ISNUMBER(MATCH("Next Day*",A2))+0 Todd F. wrote: Can you build an if statement in excel that is driven by "starts with" I have a filed that contains several text statements defining service level. I have 3 that start with "Next Day" & end with "Drive" "Over night AM" "Over night PM" I want the cel with the if statement to say soemthing simple like if it starts with Next Day place a 1 here, etc. Is there such a thing as starts with or contains in excel Thanks for your time -- [1] The SumProduct function should implicitly coerce the truth values to their Excel numeric equivalents. [2] The lookup functions should have an optional argument for the return value, defaulting to #N/A in its absence. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting rows based on IF statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
Msgbox based on If statement | Excel Worksheet Functions | |||
IF statement based on data type | Excel Worksheet Functions | |||
Conditional formatting based on if statement. | Excel Worksheet Functions |