You need to sign in to do that
Don't have an account?
rornelas
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+
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"))))
If this answer is helpful for you then mark it as the best answer.