Thread: Rounding a Formula Result Up or Down by the 100s
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kiley Kiley is offline
external usenet poster
  
Posts: 39
Default 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.
Reply With QuoteReply With Quote