Lesson Progress
0% Complete

If you haven’t already, watch our course on formula columns!

Using a formula column in the deals table, you can assign different commission rates using logical statements based on the deal size. In this case, we assign a 3% rate for deals under $10,000, 5% for deals under $100,000, 7% For deals under $200,000, and 9% for deals bigger than that.

Here is the sample code that you can use or adapt to your purposes:

if( "Deal Size" < 0,0, if("Deal Size" < 10000,.03*"Deal Size", if("Deal Size" < 100000, .05*"Deal Size", if("Deal Size" < 200000, .07 *"Deal Size", .09*"Deal Size"))))