Multiplying a Vlookup result of 0, getting a value error

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top