+ Start a Discussion
Gaurav Gulati 8Gaurav Gulati 8 

multiple if condition formula for discount calculation

If ( amount <=100 , Discount =10% , 

If ( amount <= 150 and amount >100 , Discount =20% ,

If ( amount <=200 and amount > 150 , Discount = 25% )))

Please can someone suggest the right syntax for displaying discount % in discount feild depending on value in amount feild
Best Answer chosen by Gaurav Gulati 8
Steven NsubugaSteven Nsubuga
If ( amount <=100 , 0.1, 

If ( AND(amount <= 150, amount >100 ), 0.2,

If ( AND(amount <=200, amount > 150), 0.25 )))

Use a formula field of type percent.

All Answers

Steven NsubugaSteven Nsubuga
If ( amount <=100 , 0.1, 

If ( AND(amount <= 150, amount >100 ), 0.2,

If ( AND(amount <=200, amount > 150), 0.25 )))

Use a formula field of type percent.
This was selected as the best answer
Gaurav Gulati 8Gaurav Gulati 8
Hello Steven ,

Thanks a lot for your help , it worked out for me .

Kind Reagards ,
Gaurav
Steven NsubugaSteven Nsubuga
My pleasure Gaurav, please mark it as a best answer.
Gaurav Gulati 8Gaurav Gulati 8
Done