Thread: Removing #N/A from formula results
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] paulbarleychito@gmail.com is offline
external usenet poster
  
Posts: 1
Default Removing #N/A from formula results
Hi, what if my formula a

=VLOOKUP(E4,'Hidden Local Database'!$L$1:M$5000,2,FALSE)

=C4*G4

=sum(I4:I300)

Can you write me a formula returning 0 instead of #N/A. Thanks alot.
Reply With QuoteReply With Quote