View Single Post
  #1   Report Post  
Mctabish
 
Posts: n/a
Default How would I calculate commisions (with a cap)?

I Work in an office that pays by commision. I get 30% until 10,000 dollars
have been paid. At that point, I get 90%. How would I write this in a
formula? I track each month. on a different row And the 10,000 cap is reset
each year.

My Gross Income is in Col G and I want to have the net income in col L

Thanks
Mc