Excel function not evaluating last IF Statement

I have this function that compares cells and the data that is stored within the cell.

Function: =IF($D2=$A$54,IF($H2>(2*$D$54),"Great","Low"),IF($D2=$A$55,IF($H2>(2*$D$55),"Great","Low"),IF($D2=$A$56,IF($H2>(2*$D$56),"Great","Low"),IF($D2=$A$57,IF($H2>(2*$D$57),"Great","Low"),IF($D2=$A$58,IF($H2>(2*$D$58),"Great","Low"))))))

This part of the function: IF($H2>(2*$D$57),"Great","Low"),IF($D2=$A$58,IF($H2>(2*$D$58),"Great","Low") is evaluating as False instead of the value Great or Low.

I don't understand whether or not I should use an AND or OR to make the function evaluate. Any advice would be helpful!