Formula problem

[Guest]

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!

 

[T. Valko]

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

Maybe this:

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

Copy down as needed.

Biff

 

[Guest]

We don't care if it is less than 1,000,000 though. We are more concerned if
it higher.

 

[T. Valko]

Ok, this will leave the cell blank if the number is <=1000000:

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

Biff

 

[Guest]

=IF(A1>1000000,A1*.33+400000,"Not over Million")

 

[T. Valko]

Hmmm...

I just noticed AKphidelt's relpy.

My interpretation is just the amount over 1000000, if any. Their
interpretation is the total amount if >1000000.

So, either way we got ya covered!

Biff

 

[Guest]

lol, im sure something we did is right... my interpretation came from her
last line...

" I want a statement that I want anything over 1,000,000 be multiplied by
33% + 400,000. Help! "

But who knows, i've misinterpreted a lot of things in my life, lol.

 

[Guest]

You two are funny! Thanks for the input!

=IF(A1>1000000,A1*.33+400000,"Not over Million")