Newb here, I have found similar functions when searching here but nothing which includes the multiple functions I am looking for.
See illustration below.
Sales Goal $90,000 = Comission 1% of gross profit
Sales Goal Bonus $1500 @ $100,000
Sales Cost Of Goods Profit
The results in one cell I am looking for are if an Associate is <90,000=0$
>90,000=Profit*1%
>100,000=(Profit*1%)+Bonus$1500
The individual would earn no comission on sales under 90,000
The individual would earn standard comission on sales 90,000-99,999.99
The individual would earn standard comission + bonus on sales over 100,000
I would like the formulas to include fields rather than range of fixed numbers allowing me the flexibility to adjust sales goals, comission and bonus figures accordingly. I have spent several hours attempting this with minimal results.
See illustration below.
Sales Goal $90,000 = Comission 1% of gross profit
Sales Goal Bonus $1500 @ $100,000
Sales Cost Of Goods Profit
The results in one cell I am looking for are if an Associate is <90,000=0$
>90,000=Profit*1%
>100,000=(Profit*1%)+Bonus$1500
The individual would earn no comission on sales under 90,000
The individual would earn standard comission on sales 90,000-99,999.99
The individual would earn standard comission + bonus on sales over 100,000
I would like the formulas to include fields rather than range of fixed numbers allowing me the flexibility to adjust sales goals, comission and bonus figures accordingly. I have spent several hours attempting this with minimal results.