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!
