View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jazz Jazz is offline
external usenet poster
 
Posts: 45
Default =I34*H34 without N/A

I have a worksheet with this formula =I34*H34 in J34. When cells I34 and H34
have no numbers in them J34 displays #N/A. Can you tell me how to change my
current formula =I34*H34, so that if I34 and H34 are empty J34 will remain
blank instead of displaying #N/A