I know this will be simple, but I just can't get my head around it. I need a
formula that will calculate a percentage:
If A1 500 but <1000 then A1*.02

See what I mean? if it's between those 2 numbers then it gets multiplied by
..02.

Thank you in advance for your help.
G.