+ Start a Discussion
rornelasrornelas 

Formula field for numeric ranges

Hi, Everyone,

I have a numeric field that I need help on. I have the following ranges I need to incorporate into the formula, however, when ever i add into the formula editor it does not let me compile. I know it's something simple :( Any help is greatly appreciated!!

$30-$40
$40-$50
$50-$60
$60-$70
$70-$80
$80-$90
$90-$100
$100-$125
$125-$150
$150-$175
$175-$200
$200+

 
IF (AnnualRevenue >= 30, "30-40",
IF (AnnualRevenue >= 40, "40-50",
IF (AnnualRevenue >= 50, "50-60",
IF (AnnualRevenue > 0, "no rate",
"No Score"))))

 
Best Answer chosen by rornelas
Suraj Tripathi 47Suraj Tripathi 47
Hi rornelas,
IF( AND(Budget_Rent__c >=30 , Budget_Rent__c <40),"30-40",
IF( AND(Budget_Rent__c >=40 , Budget_Rent__c <50),"40-50",
IF( AND(Budget_Rent__c >=50 , Budget_Rent__c <60),"50-60",
IF( AND(Budget_Rent__c >=60 , Budget_Rent__c <70),"60-70",
IF( AND(Budget_Rent__c >=0 , Budget_Rent__c <30),"No Rate","No Score"
)
)
)
)
)

If this answer is helpful for you then mark it as the best answer.