Skip to main content

Hello,


I have a nested IF statement shown below that seems to have correct logic yet I am getting an odd error.


Formula used in the UI-Only field:


IF({{NRR}} <= 100, ({{OriginalBook}}-{{BookWon}})*0.0025, IF({{NRR}} > 100 &amp;&amp; <= 120, {{OriginalBook}}*0.0025 + ({{BookWon}}-{{OriginalBook}})*0.0075, {{OriginalBook}}*0.0025 + ({{OriginalBook}}*0.25)*0.0075 + ({{BookWon}}-({{OriginalBook}}*1.25))*0.015))

Error:


SyntaxError: Expected "'", "(", ".", """", "date", "false", "null", "true", "undefined", [ x0C

x0B - ], [0-9], [-+!], or [a-z] but "<" found.

{{NRR}} is another formula field returning a number.

IF({{NRR}} > 100 && <= 120 This looks like it’s missing the {{NRR}} after &&


wow beautiful, thank you. Can’t believe I missed that


Reply