Multiplying a Vlookup result of 0, getting a value error

[Guest]

My spreadsheet has a column that's a Vlookup. Some of the results equal
0.00. I am multiplying that column by another column that may also have a
zero value. Whenever the value in these columns are 0's, the product becomes
a #value! error.
I want the product to be 0. How can I do this? Thanks!
khatch5995

 

[Peo Sjoblom]

That is not possible, you can only get the value error if you calculate with
text, so if you use "0", then change the values to 0 instead. You can't get
a value error if you multiply with 0