#VALUE!

[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

 

[Peo Sjoblom]

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