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

Find more posts tagged with

Accepted answers

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

All comments

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

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,

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!😊

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.