Formula problem

J

Janet

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

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
 
J

Janet

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

T. Valko

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

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

Biff
 
T

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
 
A

AKphidelt

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.
 
Top