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
|