This formula gives error 'Unexpected token >' but should not: =IF(B5<>"",IF(B6<>"",0,1),.5)
But this works: =IF(B5<>"",IF(TRUE,0,1),.5) and produces 0
Perhaps the parser chokes on repeated <>. E.g., this also produces Unexpected token >:
=AND(B5<>"",B6<>"")
