Uh oh, our client came back and changed the commissions criteria on us again! Let’s say that we now have different commission rates for Deals < $10k, < $100k, < $200k, and more. Good thing we know how to use nested IF statements.
Here’s the code:
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"))))