+ 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