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
Robin Thomas 19Robin Thomas 19 

Formula field based on ranges

I am needing help writing out a formula field. If the net income is in a certain range I need the field to display the Net by the % it corresponds with.
=Net Income MLS Wholesale X the percentage level belows


≤ $6000                     $500(flat fee)
> $6,001 ≤ $24,000     8%
> $24,001 ≤ $32,000   10%
> $32,001 ≤ $40,000   12%
> $40,001 ≤ $46,667   15%
> $46,668                 $7,000(flat fee)

 
Best Answer chosen by Robin Thomas 19
AnkaiahAnkaiah (Salesforce Developers) 
Hi Robin,

try with below formula. replace the field api name as per your org and formula field return type should be text. 
IF(Net_Income__C <= 6000 ,'$500(flat fee)',

If(AND(Net_Income__C > 6000 , Net_Income__C <= 24000 ), "8%",

If(AND(Net_Income__C > 24000 , Net_Income__C <= 32000 ), "10%",

If(AND(Net_Income__C > 32000 , Net_Income__C <= 40000 ), "12%",

If(AND(Net_Income__C > 40000 , Net_Income__C <= 46667 ), "15%",

If(Net_Income__C > 46667 ,  "$7000(flat fee)","")
)
)
)
)

)

If this helps, please mark it as best answer.

Thanks!!

All Answers

AnkaiahAnkaiah (Salesforce Developers) 
Hi Robin,

try with below formula. replace the field api name as per your org and formula field return type should be text. 
IF(Net_Income__C <= 6000 ,'$500(flat fee)',

If(AND(Net_Income__C > 6000 , Net_Income__C <= 24000 ), "8%",

If(AND(Net_Income__C > 24000 , Net_Income__C <= 32000 ), "10%",

If(AND(Net_Income__C > 32000 , Net_Income__C <= 40000 ), "12%",

If(AND(Net_Income__C > 40000 , Net_Income__C <= 46667 ), "15%",

If(Net_Income__C > 46667 ,  "$7000(flat fee)","")
)
)
)
)

)

If this helps, please mark it as best answer.

Thanks!!
This was selected as the best answer
Robin Thomas 19Robin Thomas 19
It worked but how would the formula for =Net Income MLS Wholesale X (The output) for the formula above look? For the flat fee ones it would be Net Income + $500 or $7000 and then for the percentages it would be Net Income * The percentage.