Rounding a Formula Result Up or Down by the 100s

K

Kiley

I have the following formula (=VLOOKUP(A4,'LTI Calculation'!A:N,12,FALSE)
that would give me a result of :


$150,480 and I would like to round this number up by the 100s to get $150,500
or
$650,232 and I would like to round this number down by the 100s to get
$650,200

I would like to add "Rounding" to my VLOOKUp formula above to automatically
round up or down by the 100s.
 
K

Kiley

You rock!!! Thank you so much!

Luke M said:
=ROUND(VLOOKUP(A4,'LTI Calculation'!A:N,12,FALSE),-2)

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What do these numbers mean in the rounding formula? 2
Round formula 1
Converting time to decimal then rounding 2
v look up and rounding 2
include rounding in a formula 2
ROUNDING RESULT OF CALCULATION UP OR DOWN 15
Formula Help 1
Rounding up or down to nearest whole number 1

Top