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.
|