+ Start a Discussion
Bayarea 101Bayarea 101 

Commission formula

Hi there i need some hel to create a formula to calculate coomission.
If a deal is 
<=49999 no commission
>=50000 to 99999 $100
>=100000 to 199999 $150
>=200000 to 299999 $200
>=300000 to 399999 $250
Fahad-AkhtarFahad-Akhtar
Hi,

Replace my test field  "test111__c" with your field and if none of the condition matches user will get a 0, you can change that its last 0
 
IF( 
test111__c <= 49999,0, 
IF( 
test111__c >= 50000 && test111__c <= 99999,100, 
IF( 
test111__c >= 100000 && test111__c <= 199999,150, 
IF( 
test111__c >= 200000 && test111__c <= 299999 ,200, 
IF( 
test111__c >= 300000 && test111__c <= 399999 ,250,0)))))

Thanks,
Fahad Akhtar