• Ganpati Khot 4
  • NEWBIE
  • 0 Points
  • Member since 2021

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 3
    Replies
Create a formula field that shows an opportunity’s progress:
Field Label: Contribution Level
Field Name: Contribution_Level
Formula Return Type: Text
Return values:
Less than or equal to 10%: Low
Between 10% and 40%: Medium
More than 40%: High
Hint: CASE statements can’t contain Boolean functions. Use IF statements instead.

I am entering below formula:
IF( Contribution_Percentage__c <=10,"Low", 

IF(Contribution_Percentage__c >10 && Contribution_Percentage__c <40,"Medium", 

"High"))

Still its not working....can anyone please help me here?
Create a formula field that shows an opportunity’s progress:
Field Label: Contribution Level
Field Name: Contribution_Level
Formula Return Type: Text
Return values:
Less than or equal to 10%: Low
Between 10% and 40%: Medium
More than 40%: High
Hint: CASE statements can’t contain Boolean functions. Use IF statements instead.

I am entering below formula:
IF( Contribution_Percentage__c <=10,"Low", 

IF(Contribution_Percentage__c >10 && Contribution_Percentage__c <40,"Medium", 

"High"))

Still its not working....can anyone please help me here?