View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lightfoot
 
Posts: n/a
Default Need help with a formula

We're leasing a property and the terms of our lease state that we will pay
$100/month plus 3% of sales in EXCESS of $30,000/per month.

So, if our sales were $40,000 for the month, we'd only pay 3% on $10,000.

Please help! Thanks!