#VALUE!

  • Thread starter Thread starter liamthompson
  • Start date Start date
L

liamthompson

I am multiplying a number of cells and the #value! is
being returned. One of the cells being multiplied is
showing blank but has the following vlookup formula:
IF(ISNA(VLOOKUP(E12,royalty!$A$11:$D$433,4,FALSE)),"
",VLOOKUP(E12,royalty!$A$11:$D$433,4,FALSE))

How can I remove the #value! result so that the
multiplication result is zero or a blank?

Thanks
 
Replace "" with 0

IF(ISNA(VLOOKUP(E12,royalty!$A$11:$D$433,4,FALSE)),0
,VLOOKUP(E12,royalty!$A$11:$D$433,4,FALSE))


--
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.


Regards,

Peo Sjoblom
 
Back
Top