If Statements
 

I need a statement that allows me to use a certain number in a equation for
when the number is within an range.
Example
The number range is between 4000 and 40000
So when the number in column 1 needs to be multipled by 31 if the number is
between 4000 and 40000. And column two will have the new inputs.
I need an If statement.

If Statements
 

What do you want it to do if it does not fall within the range you specified?

Storm.

"Shortstopper00" wrote:

I need a statement that allows me to use a certain number in a equation for
when the number is within an range.
Example
The number range is between 4000 and 40000
So when the number in column 1 needs to be multipled by 31 if the number is
between 4000 and 40000. And column two will have the new inputs.
I need an If statement.

If Statements
 

Just remain the same Number. Not times by 31.



"Storm" wrote:

What do you want it to do if it does not fall within the range you specified?

Storm.

"Shortstopper00" wrote:

I need a statement that allows me to use a certain number in a equation for
when the number is within an range.
Example
The number range is between 4000 and 40000
So when the number in column 1 needs to be multipled by 31 if the number is
between 4000 and 40000. And column two will have the new inputs.
I need an If statement.

If Statements
 

Assuming value is in A1 and you want the answer in B1, use this formula:

=IF(AND(A1=4000,A1<=40000),A1*31,A1)

Storm

"Shortstopper00" wrote:

Just remain the same Number. Not times by 31.



"Storm" wrote:

What do you want it to do if it does not fall within the range you specified?

Storm.

"Shortstopper00" wrote:

I need a statement that allows me to use a certain number in a equation for
when the number is within an range.
Example
The number range is between 4000 and 40000
So when the number in column 1 needs to be multipled by 31 if the number is
between 4000 and 40000. And column two will have the new inputs.
I need an If statement.