Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jun 2004
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    If Functions (NT)

    I'm about to SCREAM ... I'm trying to do a logics which basically states the following....

    =If(C5 is >.001, 1/C5+2, if(C5="ND",1, if(c5="CD",2)

    what am I doing wrong .. it will do the first part of my formula, but if the first "if" is false, and the cell is actually a ND or a CD - it's not population, only shows "VALUE" Help!

    <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: If Functions (NT)

    Try

    =IF(AND(ISNUMBER(C5),C5 >0.001), 1/C5+2, IF(C5="ND",1, IF(C5="CD",2)))

    Andrew C

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: If Functions (NT)

    Problem is that if C5 contains a text, C5>0.001 evaluates to TRUE; this may seem peculiar, but that's how Excel works. You need to build in a check to test if C5 is numeric. Your formula doesn't provide a return value if none of the conditions is met, so it will return FALSE in those cases. If that's what you want, fine, otherwise you'll have to provide return values for those cases. Here is a formula that does so:

    <code>=IF(ISNUMBER(C5),IF(C5 >0.001,1/C5+2,"smaller"),IF(C5="ND",1,IF(C5="CD",2,"other text")))</code>

  4. #4
    New Lounger
    Join Date
    Jun 2004
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: If Functions (NT)

    <img src=/S/bingo.gif border=0 alt=bingo width=15 height=22> Thanks so much, I took the last function, and instead of other text, did "2" and it seemed to work!!!!!

Posting Permissions

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