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
DRPowerUserDRPowerUser 

How to Fix "IF" Formula in Opportunity

I am trying to revise a formula to do the following:  When Opportuntiy = Closed Won, display a $$ based on the value in the custom field called 'Users'. 

 

If users <20   use $150

If users <50   use $300

If users <100 use $750

If users >=100 use $1500

 

My issue:  I'm getting a formula error that I can't resolve.

 

Any help would be appreciated.

Best Answer chosen by Admin (Salesforce Developers) 
werewolfwerewolf

Yeah, just add another level of IF.

 

 

 

IF (ISPICKVAL(Status, "Closed Won"),
	IF(
		Users__c<20,150,
		IF(
			Users__c<50,300,
			IF(
				Users__c<100,750,1500
			)
		)
	),
	0
)
 
 
 


All Answers
werewolfwerewolf
I don't know what your formula looks like now, but it should be like this:
 
 
IF(
	Users__c<20,150,
	IF(
		Users__c<50,300,
		IF(
			Users__c<100,750,1500
		)
	)
)
 
 


DRPowerUserDRPowerUser
The formula you listed is what I had working previously before I added the extra logic step of the ISPICKVAL for Closed Won.  
 
That is when I couldn't resolve the error.  Do you have any suggestions on how to properly insert the 'ISPICKVAL' for Closed Won in each line without error?
 
 


werewolfwerewolf
Yeah, just add another level of IF.
 
 
 
IF (ISPICKVAL(Status, "Closed Won"),
	IF(
		Users__c<20,150,
		IF(
			Users__c<50,300,
			IF(
				Users__c<100,750,1500
			)
		)
	),
	0
)
 
 
 
This was selected as the best answer