You need to sign in to do that
Don't have an account?
Gaurav 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
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
Use a formula field of type percent.
All Answers
Use a formula field of type percent.
Thanks a lot for your help , it worked out for me .
Kind Reagards ,
Gaurav