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!

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!

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

"T. Valko" wrote:

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!

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

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

Biff

"Janet" wrote in message
...
We don't care if it is less than 1,000,000 though. We are more concerned
if
it higher.

"T. Valko" wrote:

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!

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

"T. Valko" wrote in message
...
Ok, this will leave the cell blank if the number is <=1000000:

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

Biff

"Janet" wrote in message
...
We don't care if it is less than 1,000,000 though. We are more concerned
if
it higher.

"T. Valko" wrote:

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!

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.


"T. Valko" wrote:

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

"T. Valko" wrote in message
...
Ok, this will leave the cell blank if the number is <=1000000:

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

Biff

"Janet" wrote in message
...
We don't care if it is less than 1,000,000 though. We are more concerned
if
it higher.

"T. Valko" wrote:

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!

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


"Janet" wrote:

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!

You two are funny! Thanks for the input!

"AKphidelt" wrote:

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


"Janet" wrote:

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!