Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Blue Springs, Missouri, USA
    Posts
    108
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Understanding an IF (XL2K SR1)

    I am a little slow in my old age... I received a workbook that has a formula in one of the cells that bascially says..
    IF(ISNA(E9),FALSE, TRUE)
    Is the formula really saying that look at the value in E9 to see if it is #N/A and if it is (the FALSE portion) then say it isn't or if it isn't (the TRUE portion) leave it alone?

    TIA

    Dennis

    <img src=/S/gramps.gif border=0 alt=gramps width=20 height=20>

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Understanding an IF (XL2K SR1)

    It looks at the value of E9. If E9 returns an error value #N/A, then it returns an output of FALSE (the if true argument). If E9 is not an error of N/A, then it returns TRUE (the ifs False argument)
    Regards,
    Rudi

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

    Re: Understanding an IF (XL2K SR1)

    This formula returns FALSE is the value of E9 is #N/A, and TRUE if the value of E9 is something else. It is equivalent to the shorter formula

    =NOT(ISNA(E9))

Posting Permissions

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