Rounding a Formula Result Up or Down by the 100s
 

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.

Rounding a Formula Result Up or Down by the 100s
 

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

--
Best Regards,

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


"Kiley" wrote:

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.

Rounding a Formula Result Up or Down by the 100s
 

You rock!!! Thank you so much!

"Luke M" wrote:

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

--
Best Regards,

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


"Kiley" wrote:

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.