Formula for Red-yellow-green-gray

Question

Hello

I am trying to make the formula work but I can't seem to find what is wrong. I keep getting  #unparseable error.  Can someone help. My formula is below.

=IF([Amount Health]@row = "Good", "Green"), IF([Amount Health]@row = "Low", "Red"), IF([Amount Health]@row = "Shipping in progress", "Yellow", IF([Amount Health]@row = " " ,"Gray"))

Nik Fuentes · Accepted Answer

=IF([Amount Health]@row = "Good", "Green", IF([Amount Health]@row = "Low", "Red"), IF([Amount Health]@row = "Shipping in progress", "Yellow", IF([Amount Health]@row = " " ,"Gray"))))

The close quote after "green" was ending the if() function, causing it to get confused about what to do with the comma that followed. The above should work.