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
|