If Statements

  • Thread starter Thread starter Shortstopper00
  • Start date Start date
S

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.
 
What do you want it to do if it does not fall within the range you specified?

Storm.
 
Just remain the same Number. Not times by 31.



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

Storm.
Click to expand...
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumif number is greater than a number but less than another number 2
Does an if statement calculate both the true and false? 4
Lookup ? 4
Calc Speed & Formula simplification 2
two-variable data table question 7
Sumproduct with nested if statement 5
Greater than less than total in a column 1
Counting Cells with Multiple Range Criteria (Excel 2003) 7

Back
Top