I'm looking to create a formula that calculates sales commission from monthly sales achieved. Cell A1 will contain monthly sales achieved.
The commission structure is
o 0-2000,0%
o 2001-4000,15% (retroactive to dollar 1)
o 4001-6000,30% (30% applies to 4001-6000)
o 6001+,45% (45%...