| 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, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
| Reply |
| 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 | |||
Linear Mode
