|This is what I want the cell to do:|
If A1 is less than 100,001 then multiply by 2.05
If A1 is greater than 100,000 but less than 500,001 then multiply by 1.60
If A1 is greater than 500,000 but less than 2,000,000 then multiply by 1.05
I'm a "rookie", so any help is greatly appreciated.