using ISNA

[kinkyparamour]

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

 

[BabyTiger]

Try the following:

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

 

[Jay Petrulis]

Hi,

Try,

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

This will only trap #NA! errors.

Regards,
Jay

 

[anno]

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 ?

 

[BabyTiger]

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.

 

[kinkyparamour]

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

 

[anno]

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)

 

[kinkyparamour]

Thanks Anno,

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

Denny