Thanks:  0
Likes:  0

1. 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. Try the following:

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

3. Hi,

Try,

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

This will only trap #NA! errors.

Regards,
Jay

4. 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. 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. 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. 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. Thanks Anno,

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

Denny

## User Tag List

#### Posting Permissions

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