formula to calulate different slots of amounts

I need a formula to calulate amount;
Example:
upto 1000 $, at the rate of 1%
from 1000$ onwards 0.75%
Thanks in advance

Sorry. I didnt get an email notification for the response I got and now only I saw the response.
Normally in other forums, the moment I make a post or get a reply I am notified by email.
Extremely sorry about my ignorance, and just now only saw the answer to my previous post.

Back to the question;

Yes its a tiered calculation.

First 1000 $ should be paid at 1%
from 1000 $ onwards it is at 0.75%

Thanks and sorry.

Example;
Tax to be paid for Total earnings ;
Total earnings for 2015=3500 $
Total earnings for 2016=3750 $
Total earnings for 2017=3300 $

First 1000$ at 1% and balance at 0.75%

Therefore Tax due
year 2015 =10+ 18.75= 28.75
year 2016=10+20.625=30.625
year 2017 =10+17.25=27.25

Thanks.

Many ways to do it. One is multiply everything by 1% and then remove 0.25% from the amount above 1000

=A1*0.01-MAX(0,A1-1000)*0.0025

Thanks a lot. Will check it and confirm.

Thanks a lot. It works. Greatly appreciated.