Google Sheets Parse Error in an If/Then Formula

[AShamburger]

In Excel, I do not get an error with this formula. In Google Sheets, I get a "parse error". What do I need to do?

=IF(AND($G3>=X$1,$G3<=X$2),$G3,IF(AND($H3>=X$1,$H3<=X$2),$H3,IF(AND($J3>=X$1,$J3<=X$2),$J3,IF(AND(X$2>$G3,X$2<$H3),”y”,IF(AND(X$2>$H3,X$2<$J3),"x"," ")))))

And by the way, this formula does not return an error - I used it and just added another If statement:

=IF(AND($H3>=Y$1,$H3<=Y$2),$H3,IF(AND($J3>=Y$1,$J3<=Y$2),$J3,IF(AND(Y$2>$H3,Y$2<$J3),"x"," ")))

Does Google Sheets limit nested If/Then statements to 5?

Thank you,
Ann

 

[mole999]

Its really a question to ask of Google, they make look the same but can't be 100% comparable