MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Making #N/A show as 0


Posted by Ben on December 15, 2000 2:27 PM

How can I make cells that display #N/A to display 0 instead?

Thanks!


Posted by Aladin Akyurek on December 15, 2000 3:39 PM

=if(isna(vlookup(...)),0,vlookup(...))

Aladin

Posted by Ben on December 16, 2000 1:11 AM

Thanks!

Thanks!