Formula not working (UNPARSEABLE)

1996mustang

I have the following formula that is not working.

=IF(AND([TOTAL %]6 > 0, [TOTAL %]6 <= 0.1), "YELLOW" , IF(AND([TOTAL %]6 <= 0, [TOTAL%]6 > -0.1), "GREEN", IF([TOTAL %]6 <- 0.1, "PURPLE", IF([TOTAL %]6 > 0.1,"RED"

The return I get is (UNPARSEABLE)

Please advise if you can find the error in my formula.

Regards,

Derrick Smith

Mark Cronk

Hi @1996mustang ,

I found a typo. Missing a space. Try this:

=IF([TOTAL %]6 > 0.1,"RED", IF(AND([TOTAL %]6 > 0, [TOTAL %]6 <= 0.1), "YELLOW" , IF(AND([TOTAL %]6 <= 0, [TOTAL %]6 > -0.1), "GREEN", IF([TOTAL %]6 <= -0.1, "PURPLE" ))))

If you're evaluating multiple rows you should change [Total %]6 to [Total %]@row so the San formula can be copied down or made into a column formula.

Work?

Mark

Mark Cronk

Hi @1996mustang ,

Try:

=IF([TOTAL %]6 > 0.1,"RED", IF(AND([TOTAL %]6 > 0, [TOTAL %]6 <= 0.1), "YELLOW" , IF(AND([TOTAL %]6 <= 0, [TOTAL%]6 > -0.1), "GREEN", IF([TOTAL %]6 <= -0.1, "PURPLE" ))))

Mark

1996mustang

Mark,

Still getting #UNPARSEABLE

thanks

ds

Mark Cronk

Hi @1996mustang ,

I found a typo. Missing a space. Try this:

=IF([TOTAL %]6 > 0.1,"RED", IF(AND([TOTAL %]6 > 0, [TOTAL %]6 <= 0.1), "YELLOW" , IF(AND([TOTAL %]6 <= 0, [TOTAL %]6 > -0.1), "GREEN", IF([TOTAL %]6 <= -0.1, "PURPLE" ))))

If you're evaluating multiple rows you should change [Total %]6 to [Total %]@row so the San formula can be copied down or made into a column formula.

Work?

Mark

1996mustang

That worked! Thank you for your help!

Regards,

ds

Mark Cronk

Happy to help. Please mark my answer as accepted to close the discussion. Thank you for using the Community.

Be Well, Mark

1996mustang

Mark was a great help!😊