Forum Discussion
Solved
Multiplication with Formulas and VLookup incorrect
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.
- That is almost certainly because 0.53 is not 0.5300000000 but rather something like 0.5333333 and hence rounds up to 7.47 but if you want to cut off the 0.53 then you need to apply a rounding function like ROUND() either in column Q or S like
=ROUND(VLOOKUP(.....) , 2)
or
=ROUND(Q10,2) * R10
2 Replies
- That is almost certainly because 0.53 is not 0.5300000000 but rather something like 0.5333333 and hence rounds up to 7.47 but if you want to cut off the 0.53 then you need to apply a rounding function like ROUND() either in column Q or S like
=ROUND(VLOOKUP(.....) , 2)
or
=ROUND(Q10,2) * R10- OMG thank you so much. I used the first formula you suggested and it cleared it all up. THANK YOU!
