Create Your Own Nested IF Statement

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"))))