software

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!

Try something like this:

For sales amount in A1

B1: =100 MAX(A1-30000,0)*3%Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Lightfootquot; wrote:

gt; We're leasing a property and the terms of our lease state that we will pay
gt; $100/month plus 3% of sales in EXCESS of $30,000/per month.
gt;
gt; So, if our sales were $40,000 for the month, we'd only pay 3% on $10,000.
gt;
gt; Please help! Thanks!

Perfect!! Thank you so much!

quot;Ron Coderrequot; wrote:

gt; Try something like this:
gt;
gt; For sales amount in A1
gt;
gt; B1: =100 MAX(A1-30000,0)*3%
gt;
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Lightfootquot; wrote:
gt;
gt; gt; We're leasing a property and the terms of our lease state that we will pay
gt; gt; $100/month plus 3% of sales in EXCESS of $30,000/per month.
gt; gt;
gt; gt; So, if our sales were $40,000 for the month, we'd only pay 3% on $10,000.
gt; gt;
gt; gt; Please help! Thanks!