Microsoft Excel - VLOOKUP formula and how to round the result

Hi, I have only just started using VLOOKUP and wonder why I haven't used this before, it's great. I have a formula thats working but I now want to round the result, I have been searching to see where the correct place to add the round function but can't find any answers.

My formula is =B8*VLOOKUP(B8,Markups!A100:I138,2,TRUE)

Can I add round up to this so that the result shows and is rounded to the nearest .05.

Thanks in advance for your help.

try this:

=ROUND(B8*VLOOKUP(B8,Markups!A100:I138,2,TRUE),0)

Thanks,

Hi, I have tried adding what you suggested and a result that was $23.41 was rounded up to $24.00 and a result of $19.91 is rounded up to $20.00, all I need to do is to round to the closest 5 cents, or round up to the closest 5 cents. What do I need to do to the formula to adjust to do this ?

Hi,

You need to place the vlookup inside the round function like this =B8*ROUND(VLOOKUP(B8,Markups!A100:I138,2,TRUE).

Hope this works for you.

Pete