Nested IF Statement Resulting in #NAME?

[davisshannon]

I have a formula that is partially working. There are multiple IF statements nested, and the first two actually perform correctly. Once I get into a couple of layers it starts to result in #NAME?. When I click on the various statements within Excel it seems to work through the logic correct, so I'm at a loss as to why this isn't working. Here is my formula if anyone can pick out where I may have a syntax error. I've highlighted the level where it starts breaking.

=IF($D13>0,
IF($E13="yes",
HLOOKUP($L13,VGW_WAN,2,TRUE),
IF(($F13="no"),
IF(($I13=“no”),
IF($H13="no",
HLOOKUP($L13,SDI_WAN,5,TRUE),
HLOOKUP($L13,SDI_WAN,2,TRUE)),
HLOOKUP($L13,SDI_WAN,3,TRUE)),
HLOOKUP($L13,CX_WAN,2,TRUE)
)
),
""
)

Thanks

 

[davisshannon]

I've cleaned up my parentheses a bit, but still hitting the same error. New code here:

=IF($D13>0,
IF($E13="yes",
HLOOKUP($L13,VGW_WAN,2,TRUE),
IF($F13="no",
IF($I13=“no”,
IF($H13="no",
HLOOKUP($L13,SDI_WAN,5,TRUE),
HLOOKUP($L13,SDI_WAN,2,TRUE)),
HLOOKUP($L13,SDI_WAN,3,TRUE)),
HLOOKUP($L13,CX_WAN,2,TRUE))),
"")

 

[davisshannon]

Just picked up my error once I pasted the code here. My "" in line 5 weren't correct for some reason. I retyped them and they appeared correctly now, and the code works.