Thread: #N/A
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard Richard is offline
external usenet poster
 
Posts: 709
Default #N/A

I've got two formulas that display the #N/A when there is no data input. How
can I get rid of this and show nothing.
=Ceiling(B3/E3/F3*G3,3) and =VLOOKUP(A3,Part_Number,3,False)
Thanks in Advance!!