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
Brett Roberts 15Brett Roberts 15 

Formula Field Help - #

Trying to expand on this formula:

IF(
ISBLANK(Total_of_Associations__c),
3000,
Total_of_Associations__c  *  65)

The formula should work in the following way:

If Total # of Associations is blank or equal to 0, this formula field should equal 3000.
If Total # of Associations is has a value of 1-9, this formula field should equal 500.
If Total # of Associations is has a value of 10+, this formula field should 
 take the value of the Total_of_Associations__c field and multiply it by 65.

Any idea?
Best Answer chosen by Brett Roberts 15
AbhinavAbhinav (Salesforce Developers) 
Check This:

I think It should work
  
IF( OR(ISBLANK( Total_of_Association__c ),Total_of_Association__c= 0) ,
3000,
IF(And(Total_of_Association__c>0,Total_of_Association__c<10),
500, Total_of_Association__c*65)
)

If it helps please mark it as best answer.

Thanks!