View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kbouquet kbouquet is offline
external usenet poster
 
Posts: 1
Default Get rid of #VALUE, after multiplying

If my formula is trying to multiply one empty field with another empty field
that is fine.
But if I am trying to multiply an empty field with another empty field that
has a formula in it (specifically a VLOOKUP) I get a #VALUE error. How do I
get that to go away and be ignored?