# Range formulas

This is a discussion on Range formulas within the Excel Questions forums, part of the Question Forums category; How do I create an if function with more than one condition. ex 1 - I need a cell to ...

1. ## Range formulas

How do I create an if function with more than one condition.

ex 1 - I need a cell to to give N/A if the a source cell is either 0 or N/A and a calc if not.

ex 2 - I need a cell to give a an affirmitive if a number in a source cell is in a range ie greater than 1 and less than 5

Thanks

2. ## Re: Range formulas

Originally Posted by wreakhav0c
How do I create an if function with more than one condition.

ex 1 - I need a cell to to give N/A if the a source cell is either 0 or N/A and a calc if not.

ex 2 - I need a cell to give a an affirmitive if a number in a source cell is in a range ie greater than 1 and less than 5

Thanks
These should work OK.

1- IF(OR(ISNA(A1),A1=0),#N/A,YourCalc)

2- IF(AND(A1>1,A1<5),TRUE,FALSE)

nt

4. ## also

what if i need an affirmative for a number in the ranges between -1and-5, and 1-5

5. Not tested-

IF(OR(AND(A1>1,A1<5),AND(A1<-1,A1>-5)),TRUE,FALSE)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•