Hi All,

We are selling a suite of products and services.  Each product / service has a commission payout from our partner.  The length of the term we sell (12/24,36/48, or 60 months) determines the commission multiplier for the products.

Currently, in CRM, we have created 3 separate formula fields that map out the commissions based on the 3 term groups mentioned above.

Our preference would be to only have a single formula field though which is adjusted based on the term length the user selects in the CRM.

I am struggling to get this created.  Likely my lack of knowledge on the various formula types.

In a perfect world, if the user selects 12/24 months or 24/36 months, or 60 months, the system will handle the appropriate calculation and spit it out in the formula field in the CRM.

I've attached a redacted screenshot that will give you an idea of what I'm after.