Multiplying a Vlookup result of 0, getting a value error
 

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

Multiplying a Vlookup result of 0, getting a value error
 

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


--
Regards,

Peo Sjoblom



"khatch5995" wrote in message
...
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