Forum Discussion

Copper Contributor

Feb 04, 2021

Excel Formula Help

I am having a problem with a formula designed to calculate a commission rate that is taking 30% of the gross revenue. There is a minimum amount of $50 if the gross revenue is $50 or less. My formul...

Backup Revised Commission Report Template 2.3.2021.xlsx371 KB

Formulas and Functions

ederdzinski

Copper Contributor

Feb 04, 2021

Thank you for your help! I am still seeing 50 in column S. Could that be caused by the formula in column Q that is subtracting revenue from expenses?

Riny_van_Eekelen

Platinum Contributor

Feb 05, 2021

ederdzinski Sorry, my mistake. Try this in S11 and copy down.

=IF(Q11=0,0,MAX(50,Q11*0.3))

ederdzinski
Copper Contributor
Feb 05, 2021
That did it! Thank you for your help!!

Riny_van_Eekelen
- Riny_van_Eekelen
  Platinum Contributor
  Feb 05, 2021
  ederdzinski Happy I could fix it for you!