Equation for calculating Gross Annual Sales

Joined
Jan 10, 2024
Messages
1
Reaction score
0
I have a lease that states I receive 10% of gross annual sales in excess of $100,000 up to $125,000 and 14% of gross annual sales over $125,000.

If I have the total gross annual sales in one column, is there an equation
that I can use that will take the 10% gross annual sales in excess of $100,000 up to $125,000 and 14% of gross annual sales over $125,000.
 
Top