Formula not working

=IF([ME %]5=N/A,"",IF(AND([ME %]5 > 0,[ME %]5 <= 0.1),"Yellow",IF(AND([ME %]5 <= 0,[ME %]5 > -0.1),"Green",IF([ME %]5<-0.1,"Purple",IF([ME %]5 > 0.1, "Red"

Does anybody know why the above formula doesn't work? I keep getting (Unparseable) in the cell. Help.

Thank you in advance.

DS

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!