nested if

J

Janis

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top