As the subject line says, I'm over my head. I want to put a number
into cell A1 that yields a result in cell A2, but there are a up to
three factors involved. Maybe I'm WAY over my head.

Example:

If Cell A is <=1000000 then the result = 5% of the number
If Cell A is 1000000 and <2000000 then the result needs to equal 5%
on the first 1,000,000 (or what ever number is in there) plus 4% on
what ever number is there
If Cell A is 3000000 then the result needs to equal 5% on the first
1,000,000, plus 4% on the next 1,000,000, and 3% on the remaining
number

In english:
Cell A = 1,000,000 then the result is 50,000 (1,000,000 * 5% = 50,000)
Cell A = 2,000,000 then the result is 90,000 (1,000,000 * 4% = 40,000
+ 50,000)
Cell A is 3,000,000 then the result is 120,000 (1,000,000 * 3% =
30,000 + 40,000 + 50,000)

Can this be done or do I have to write this out as three different
formulas and have a simple SUM total all three cells?

I hope I'm making sense.

Thanks.

Chip