Sign Up ›
  • Balaji Vadlamudi 5
  • NEWBIE
  • 0 Points
  • Member since 2021
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
SOLVED
5 replies

Need help with formula field that will show text value based off number range of field. So if value is >=0 and <=1 then Laggard would be the text value in field

Here are several examples that I've tried and can't get them to work. Any help would be appreciated to get either one of these working or if there is another easier way to write the formula.

Thanks,

Example 1:
IF(ePro_ROI_Soft_Hard_Rank__c >= 0  || <= 1,"Laggard",
IF(ePro_ROI_Soft_Hard_Rank__c > 1  || <= 2,"Low Performer",
IF(ePro_ROI_Soft_Hard_Rank__c > 2  || <= 3,"Average",
IF(ePro_ROI_Soft_Hard_Rank__c > 3  || <= 4,"High Performer",
IF(ePro_ROI_Soft_Hard_Rank__c > 4  || <= 5,"Best in Class"
)
)
)
)
)

Example 2:
IF(ePro_ROI_Soft_Hard_Rank__c >= 0,"Laggard",
IF(ePro_ROI_Soft_Hard_Rank__c <= 1,"Laggard",
IF(ePro_ROI_Soft_Hard_Rank__c > 1,"Low Performer",
IF(ePro_ROI_Soft_Hard_Rank__c <= 2,"Low Performer",
IF(ePro_ROI_Soft_Hard_Rank__c > 2,"Average",
IF(ePro_ROI_Soft_Hard_Rank__c <= 3,"Average",
IF(ePro_ROI_Soft_Hard_Rank__c > 3,"High Performer",
IF(ePro_ROI_Soft_Hard_Rank__c <= 4,"High Performer",
IF(ePro_ROI_Soft_Hard_Rank__c > 4,"Best in Class",
IF(ePro_ROI_Soft_Hard_Rank__c <= 5,"Best in Class"))))))))))