I want to create the labels of "green","yellow", or "red" depending on the value found in a certain cell.

-5000 -> 0 & 0 -> 5000 are green
-50000 -> -5000 & 5000 ->50000 are yellow
anything lower than -50000 & anything higher than 50000 is red

the current formula I have is this :

=IF(I9<"-50000","red",IF(I9>="-50000","yellow",IF(I9>"-15000",IF(I9<=15000,"green",IF(I9<=50000,"yellow",IF(I9>50000,"red"))))))

I keep getting everything as red whenever I include the negative numbers. Please help!