Formula problem
 

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!

Formula problem
 

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!

Formula problem
 

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!

Formula problem
 

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!

Formula problem
 

=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!

Formula problem
 

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!

Formula problem
 

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!

Formula problem
 

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!