## Here's how to create a formula that calculates different commission rates

This formula will sum all the commissions, but once added to a table widget on a dashboard, it will show the individual commission rates of each employee.

If the won amount is between 1000 and 1999, give 1%

If the won amount is between 2000 and 2999, give 5%

If the won amount is higher than 3000, give 10%

`(`

(Sum(Closed deal,Amount>=1000&Amount<2000,Amount)*0.01)+

(Sum(Closed deal,Amount>=2000&Amount<3000,Amount)*0.05)+

(Sum(Closed deal,Amount>=3000,Amount)*0.1)

)