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.
|