# Formula not working (UNPARSEABLE)

Options

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

• ✭✭✭✭✭✭
Options

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

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• ✭✭✭✭✭✭
Options

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

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• Options

Mark,

Still getting #UNPARSEABLE

thanks

ds

• ✭✭✭✭✭✭
Options

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

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• Options

That worked! Thank you for your help!

Regards,

ds

• ✭✭✭✭✭✭
Options

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

Be Well, Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• Options

Mark was a great help!😊