Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: using ISNA

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Florida
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I know this is simple but I am missing something. How can I incorporate ISNA into this formula?

    =IF($N$26>0,$n$26,$o$26)

    I want to show 0 if #N/A error.

    Thank you,
    Denny

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Wellington
    Posts
    115
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try the following:

    =IF(ISERROR($N$26),0,IF($N$26>0,$n$26,$o$26))

  3. #3
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    Try,

    =IF(ISNA($N$26),0,IF($N$26>0,$n$26,$o$26))

    This will only trap #NA! errors.

    Regards,
    Jay

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How can I incorporate ISNA into this formula?

    =IF($N$26>0,$n$26,$o$26)

    if you want to show 0 if #N/A error you could use =IF(ISNA($N$26),0,$N$26), or should it be =IF(ISNA($N$26),0,$O$26) - did you want the formula to show N26 or O26 if it was not #N/A ?

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    Wellington
    Posts
    115
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I believe Jay's formula did the trick. Because ISNA come first, then the second IF statement to identify the value/location of the wanted cell.

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    Florida
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorry,
    I should have been clearer. If the value in n26 is #n/a I want the value stored in 026 to be shown. Using the formulas above I get a 0 if the value in n26 is NOT #n/a. Just what I asked for...but not what I wanted ;o)

    Thanks again
    Denny

  7. #7
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorry,
    I should have been clearer. If the value in n26 is #n/a I want the value stored in 026 to be shown. Using the formulas above I get a 0 if the value in n26 is NOT #n/a. Just what I asked for...but not what I wanted ;o)

    try
    =IF(ISNA(N26),O26,0)

  8. #8
    Board Regular
    Join Date
    Feb 2002
    Location
    Florida
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Anno,

    That did the trick and as always I was able to learn something.

    Denny

Some videos you may like

User Tag List

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
  •