function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Vicky Fathers 13Vicky Fathers 13 

if -- with three options

Hi - I'm not good with formulae...

I have a number field - Support, 
I'd like a new formula field - 
if value is <10, "low"
if value 10-18 "high"
if value >18 "incomplete"

I can see how to do an if based on <10, going low/high... but needing the 3rd option has got me stuck.
Maharajan CMaharajan C
Hi Vicky,

Please try the below formula:
  
IF(Support__c < 10, "low",
IF(AND(Support__c >= 10, Custom_Auto_No__c <= 18), "high",
IF(Support__c > 18, "incomplete",
"")
)
)

Thanks,
Maharajan.C
Vicky Fathers 13Vicky Fathers 13
Hi Maharaja Thank you for helping. I get a syntax error - Error: Compiled formula is too big to execute (7,016 characters). Maximum size is 5,000 characters Best wishes Vicky