You didn't say what to do if the value is <=1000000.

Maybe this:

=IF(A11000000,(A1-1000000)*0.33+400000,A1)

Copy down as needed.

Biff

"Janet" wrote in message
...
Here's the set up:
A1 has 300,000
A2 has 1,000,000
A3 has 1,200,000

I want an if statement that if one of the following is above 1,000,000
then
to multiply by 33% + 400,000. I want a statement that I want anything over
1,000,000 be multiplied by 33% + 400,000. Help!