I have a workbook utilizing VLookup that the results display correctly i.e., 0.53 is the correct answer in the amount column. I want to multiply that against 14 (number of supplement pills). My formula for the total of 0.53 x 14 equals $7.47 but really the answer should be $7.42.

​I have a workbook utilizing VLookup that the results display correctly i.e., 0.53 is the correct answer in the amount column. I want to multiply that against 14 (number of supplement pills). My formula for the total of 0.53 x 14 equals $7.47 but really the answer should be $7.42.   Read More

​