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.