Formula not working (UNPARSEABLE)
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
Best Answer
-
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.
Answers
-
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.
-
Mark,
Still getting #UNPARSEABLE
thanks
ds
-
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.
-
That worked! Thank you for your help!
Regards,
ds
-
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.
-
Mark was a great help!😊
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives