 • Andrew Chappell
• NEWBIE
• 0 Points
• Member since 2016

• Chatter
Feed
• 0
• 1
• 0
Likes Given
• 1
Questions
• 0
Replies
We are trying to create a field formula to calculate commissions based on down payment percentage. The IF formula is slightly too big. Any suggestions to make this formula fit?

IF(Down_Payment_Percent__c >= 0.1 && Down_Payment_Percent__c <= 0.2499, Amount *0.08,

IF(Down_Payment_Percent__c >= 0.25 && Down_Payment_Percent__c <= 0.4999, Amount *0.09,

IF(Down_Payment_Percent__c >= 0.5 && Down_Payment_Percent__c <= 0.7499, Amount *0.10,

IF(Down_Payment_Percent__c >= 0.75 && Down_Payment_Percent__c <= 0.9999, Amount *0.11,

IF(Down_Payment_Percent__c >= 1 , Amount *0.12,0)))))

Thanks
• • September 13, 2016
• Like
• 1
We are trying to create a field formula to calculate commissions based on down payment percentage. The IF formula is slightly too big. Any suggestions to make this formula fit?

IF(Down_Payment_Percent__c >= 0.1 && Down_Payment_Percent__c <= 0.2499, Amount *0.08,

IF(Down_Payment_Percent__c >= 0.25 && Down_Payment_Percent__c <= 0.4999, Amount *0.09,

IF(Down_Payment_Percent__c >= 0.5 && Down_Payment_Percent__c <= 0.7499, Amount *0.10,

IF(Down_Payment_Percent__c >= 0.75 && Down_Payment_Percent__c <= 0.9999, Amount *0.11,

IF(Down_Payment_Percent__c >= 1 , Amount *0.12,0)))))

Thanks
• • September 13, 2016
• Like
• 1