Friday, 6 April 2012

Remove #N/A errors - Excel

Overview   =IF(ISNA(lookup),0,lookup)  

#N/A errors are replaced with 0.
Example   =IF(ISNA(VLOOKUP(A1,D1:E5,2,0)),0,VLOOKUP(A1,D1:E5,2,0))
  

Posted by at No comments:
Insert today's date - Excel

Type   Ctrl  ; 
 
Posted by at 1 comment:
Insert current time - Excel

Type   Ctrl   Shift   :  
   
Posted by at No comments:
Subscribe to: Comments (Atom)