Why does EXCEL nested IF return FALSE rather than returning a value

screen shot showing formulas

screen shot showing results

The IF statement in question is the one in G56.

I other cases, I've seen EXCEL display an error message pointing out a syntax error but in this case it's not displaying any error.

I've placed some comments in the spreadsheet to explain what I'm trying to accomplish. Refer to the screenshot.