I'm wondering why this formula isn't working and was hoping for some help, as I think I'm missing something small. I'm trying to translate a numeric health score into colors based on ranges in a formula field.
IF(
RecordType.Name <> "Customer",
"",
IF(
ISNULL (Product_Usage_Health_Score__c ),
IF(
Product_Usage_Health_Score__c <= 0.5,
"Red",
"ND"
),
IF(
Product_Usage_Health_Score__c > 0.5 || Product_Usage_Health_Score__c < 0.7,
"Yellow",
"ND"
),
IF(
Product_Usage_Health_Score__c >= 0.7,
"Green",
"ND"
)
)
)
Error: "Incorrect number of parameters for function 'IF()'; Expected 3, received 4
Thank you for the help!