If Statements

[Shortstopper00]

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.

 

[Storm]

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

Storm.

 

[Shortstopper00]

Just remain the same Number. Not times by 31.

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

Storm.

 

[Storm]

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