Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
using nested OR | Excel Worksheet Functions | |||
Nested Ifs | Excel Worksheet Functions | |||
More than 16 nested IFs!!!! | Excel Worksheet Functions | |||
Run out of nested Ifs | Excel Worksheet Functions |