Fix a #VALUE! error


Excel 2013

  • Text and numbers don't mix very well in Excel formulas, so make sure your numbers are actually formatted as numbers.

Excel 2016

  • Text and numbers don't mix very well in Excel formulas, so make sure your numbers are actually formatted as numbers.