I'm trying to write an if/countif function for the following situation:

if column L has the 2nd and 3rd #s that are "01" then write "01" in column M
if column L has the 2nd and 3rd #s that are "02" then write "02" in column
M, etc.
all the way to 12. (01, 02,....12 standing for the days of the month.)

I wrote:
if(countif(L3,"?01*"),"01",if(countif(L3,"?02*")," 02",if(countif(L3,"?03*"),"03", etc.
but it's wrong b/c I don't know how to write a long if function.

Can someone help?

So, you basically just want to return the 2nd and 3rd characters from the
string in column L? Try this:

=MID(L3,2,2)

HTH,
Elkar


"Studebaker" wrote:

I'm trying to write an if/countif function for the following situation:

if column L has the 2nd and 3rd #s that are "01" then write "01" in column M
if column L has the 2nd and 3rd #s that are "02" then write "02" in column
M, etc.
all the way to 12. (01, 02,....12 standing for the days of the month.)

I wrote:
if(countif(L3,"?01*"),"01",if(countif(L3,"?02*")," 02",if(countif(L3,"?03*"),"03", etc.
but it's wrong b/c I don't know how to write a long if function.

Can someone help?

Are these dates you're working with?

What's in L3? You'll need to show us some examples.

--
Biff
Microsoft Excel MVP


"Studebaker" wrote in message
...
I'm trying to write an if/countif function for the following situation:

if column L has the 2nd and 3rd #s that are "01" then write "01" in column
M
if column L has the 2nd and 3rd #s that are "02" then write "02" in
column
M, etc.
all the way to 12. (01, 02,....12 standing for the days of the month.)

I wrote:
if(countif(L3,"?01*"),"01",if(countif(L3,"?02*")," 02",if(countif(L3,"?03*"),"03",
etc.
but it's wrong b/c I don't know how to write a long if function.

Can someone help?

That is so Cool!
And it works with letter's as well!
What are some of the boundaries of this equation?
--
Thanks and God bless you and yours,
Gabriella777_2



"Elkar" wrote:

So, you basically just want to return the 2nd and 3rd characters from the
string in column L? Try this:

=MID(L3,2,2)

HTH,
Elkar


"Studebaker" wrote:

I'm trying to write an if/countif function for the following situation:

if column L has the 2nd and 3rd #s that are "01" then write "01" in column M
if column L has the 2nd and 3rd #s that are "02" then write "02" in column
M, etc.
all the way to 12. (01, 02,....12 standing for the days of the month.)

I wrote:
if(countif(L3,"?01*"),"01",if(countif(L3,"?02*")," 02",if(countif(L3,"?03*"),"03", etc.
but it's wrong b/c I don't know how to write a long if function.

Can someone help?

That's exactly what I needed. Thank you so much!

"Elkar" wrote:

So, you basically just want to return the 2nd and 3rd characters from the
string in column L? Try this:

=MID(L3,2,2)

HTH,
Elkar


"Studebaker" wrote:

I'm trying to write an if/countif function for the following situation:

if column L has the 2nd and 3rd #s that are "01" then write "01" in column M
if column L has the 2nd and 3rd #s that are "02" then write "02" in column
M, etc.
all the way to 12. (01, 02,....12 standing for the days of the month.)

I wrote:
if(countif(L3,"?01*"),"01",if(countif(L3,"?02*")," 02",if(countif(L3,"?03*"),"03", etc.
but it's wrong b/c I don't know how to write a long if function.

Can someone help?