nested if

[Guest]

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,

 

[Guest]

Try this:

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

HTH,
Elkar

 

[Trevor Shuttleworth]

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

Regards

Trevor

 

[T. Valko]

Try it like this:

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