nested if
 

I don't think I have the ending quite right:

if(isna(n4)),if(J4 = .70)),L4,"")

What I want is if N4 is na AND if J4 = .70 then I want the value in L4 else
I don't want a value. I'm trying to get all the new values on the ones that
aren't matched from a vlookup in n4.

tia,

nested if
 

Try this:

=IF(AND(ISNA(N4),J4=0.7),L4,"")

HTH,
Elkar


"Janis" wrote:

I don't think I have the ending quite right:

if(isna(n4)),if(J4 = .70)),L4,"")

What I want is if N4 is na AND if J4 = .70 then I want the value in L4 else
I don't want a value. I'm trying to get all the new values on the ones that
aren't matched from a vlookup in n4.

tia,

nested if
 

=IF(AND(ISNA(N4),J4=.7),L4,"")

Regards

Trevor


"Janis" wrote in message
...
I don't think I have the ending quite right:

if(isna(n4)),if(J4 = .70)),L4,"")

What I want is if N4 is na AND if J4 = .70 then I want the value in L4
else
I don't want a value. I'm trying to get all the new values on the ones
that
aren't matched from a vlookup in n4.

tia,

nested if
 

Try it like this:

=IF(AND(ISNA(N4),J4=0.7),L4,"")

--
Biff
Microsoft Excel MVP


"Janis" wrote in message
...
I don't think I have the ending quite right:

if(isna(n4)),if(J4 = .70)),L4,"")

What I want is if N4 is na AND if J4 = .70 then I want the value in L4
else
I don't want a value. I'm trying to get all the new values on the ones
that
aren't matched from a vlookup in n4.

tia,