Range formulas

[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

 

[Mudface]

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)

 

[wreakhav0c]

thanks mudface

nt

 

[wreakhav0c]

also

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

 

[Mudface]

Not tested-

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