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 formu...
- 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
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
=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!