using ISNA

kinkyparamour

Board Regular
Joined
Feb 16, 2002
Messages
82
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
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
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 ?
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
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)
 
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,172
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top