Formula Help

[Shmeetbag]

I need help with a formula on the following scenario:

A1 will have a variable number.

I need a formula that will return a different % based on how large the number inputed is.

EX

If the number is between 1000-1999, then return 1%
If the number is between 2000-2999, then return 2%
If the number is between 3000-3999, then return 2.5%
If the number is between 4000-4999, then return 4%

In the same formula, I need 25% of the prior % returned.

So if the number inputed is 2000 it would return 10 (2000x.02x.25)

I have tried the IF function, but can't get past the first part of the calculation.

=IF(F2>=1000>1999,F2*0.01,IF(F2>=2000>2999,F2*0.02,""))

I appreciate any help on this

 

[Shmeetbag]

Both solutions work well, Thanks alot guys.