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

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

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

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.

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.