Results 1 to 5 of 5

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. #1
    Board Regular
    Join Date
    Nov 2002
    Posts
    50

    Default 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. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339

    Default Re: Range formulas

    Quote 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)

  3. #3
    Board Regular
    Join Date
    Nov 2002
    Posts
    50

    Default thanks mudface

    nt

  4. #4
    Board Regular
    Join Date
    Nov 2002
    Posts
    50

    Default also

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

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339

    Default

    Not tested-

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

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com