Nested IF and MID functions

=IF(MID(D2,4,1)>="A",D2,"")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jan Buckley" <[email protected]> wrote in message
news:[email protected]...
> I am trying to use a MID function with an IF statement and keep getting an
> error prompt. I can enter the MID function with no problem: MID(D2,4,1) IF
> the 4th digit of the info in cell D2 is an A or greater, then I want to
see
> D2 in my cell, otherwise I don't want anything. Help!

ONe way:

=IF(MID(D2,4,1)>="A",D2,"")

You may be surprised by the results of >="A". Post back with more info
if you need another criterion.

In article <[email protected]>,
"Jan Buckley" <[email protected]> wrote:

> I am trying to use a MID function with an IF statement and keep getting an
> error prompt. I can enter the MID function with no problem: MID(D2,4,1) IF
> the 4th digit of the info in cell D2 is an A or greater, then I want to see
> D2 in my cell, otherwise I don't want anything. Help!

=IF(MID(D2,4,1)>="A",D2,"")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jan Buckley" <[email protected]> wrote in message
news:[email protected]...
> I am trying to use a MID function with an IF statement and keep getting an
> error prompt. I can enter the MID function with no problem: MID(D2,4,1) IF
> the 4th digit of the info in cell D2 is an A or greater, then I want to
see
> D2 in my cell, otherwise I don't want anything. Help!

ONe way:

=IF(MID(D2,4,1)>="A",D2,"")

You may be surprised by the results of >="A". Post back with more info
if you need another criterion.

In article <[email protected]>,
"Jan Buckley" <[email protected]> wrote:

> I am trying to use a MID function with an IF statement and keep getting an
> error prompt. I can enter the MID function with no problem: MID(D2,4,1) IF
> the 4th digit of the info in cell D2 is an A or greater, then I want to see
> D2 in my cell, otherwise I don't want anything. Help!

I am trying to use a MID function with an IF statement and keep getting an
error prompt. I can enter the MID function with no problem: MID(D2,4,1) IF
the 4th digit of the info in cell D2 is an A or greater, then I want to see
D2 in my cell, otherwise I don't want anything. Help!

=IF(MID(D2,4,1)>="A",D2,"")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jan Buckley" <[email protected]> wrote in message
news:[email protected]...
> I am trying to use a MID function with an IF statement and keep getting an
> error prompt. I can enter the MID function with no problem: MID(D2,4,1) IF
> the 4th digit of the info in cell D2 is an A or greater, then I want to
see
> D2 in my cell, otherwise I don't want anything. Help!

ONe way:

=IF(MID(D2,4,1)>="A",D2,"")

You may be surprised by the results of >="A". Post back with more info
if you need another criterion.

In article <[email protected]>,
"Jan Buckley" <[email protected]> wrote:

> I am trying to use a MID function with an IF statement and keep getting an
> error prompt. I can enter the MID function with no problem: MID(D2,4,1) IF
> the 4th digit of the info in cell D2 is an A or greater, then I want to see
> D2 in my cell, otherwise I don't want anything. Help!