I am having some trouble with a happiness meter formula field based on NPS score in our surveys.
Here is what I have so far:
IF( NPS__c >= 9, IMAGE("/resource/Misery09", "Promoter"),
IF( NPS__c <= 8.99 || NPS__c > 7, IMAGE("/resource/Misery05", "Neutral"),
IF (NPS__c <= 6.99 || NPS__c >= 1, IMAGE("/resource/Misery06", "Detractor"),
TEXT(1)
)))
Promoter and Neutral work for these ranges. But the check for Detractors returns the Neutral image. I see that || is evaluating AND. Any ideas on a better approach?