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
Leyadk DevelLeyadk Devel 

Formula help requested

Please can someone help me with the below formula? I'm trying to create a formula which will return text into it depending on what range a number falls into.

 

IF(AND(Aggregate_Monthly_KPI_OPS_Score__c >=0, Aggregate_Monthly_KPI_OPS_Score__c <=0.99)),"Unacceptable Supplier",

IF(AND(Aggregate_Monthly_KPI_OPS_Score__c >=1, Aggregate_Monthly_KPI_OPS_Score__c <=1.99)), "Unsatisfactory Supplier",

IF(AND(Aggregate_Monthly_KPI_OPS_Score__c >=2, Aggregate_Monthly_KPI_OPS_Score__c <=2.99)), "Acceptable Supplier",

IF(AND(Aggregate_Monthly_KPI_OPS_Score__c >=3, Aggregate_Monthly_KPI_OPS_Score__c <=3.99)), "Clear Over-Performance",

IF(AND(Aggregate_Monthly_KPI_OPS_Score__c >=4, Aggregate_Monthly_KPI_OPS_Score__c <=4.99)), "Clear Over-Performance", “Null”

Steve :-/Steve :-/

You don't need the AND's and you don't need to compaer the same score twice, IF statements are mutually exclusive.  Either one of these should work for you.

 

IF( Aggregate_Monthly_KPI_OPS_Score__c <= 0.99,"Unacceptable Supplier",
IF( Aggregate_Monthly_KPI_OPS_Score__c <=1.99, "Unsatisfactory Supplier",
IF( Aggregate_Monthly_KPI_OPS_Score__c <=2.99, "Acceptable Supplier",
IF( Aggregate_Monthly_KPI_OPS_Score__c <=3.99, "Clear Over-Performance",
IF( Aggregate_Monthly_KPI_OPS_Score__c <=4.99, "Clear Over-Performance", NULL)))))


IF( Aggregate_Monthly_KPI_OPS_Score__c >= 4, "Clear Over-Performance", 
IF( Aggregate_Monthly_KPI_OPS_Score__c >= 3, "Clear Over-Performance",
IF( Aggregate_Monthly_KPI_OPS_Score__c >= 2, "Acceptable Supplier",
IF( Aggregate_Monthly_KPI_OPS_Score__c >= 1, "Unsatisfactory Supplier",
IF( Aggregate_Monthly_KPI_OPS_Score__c <= 0.99,"Unacceptable Supplier",
NULL)))))

 
Steve :-/Steve :-/

are you all set with this or do you still need help?