| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding the result of two times | Excel Worksheet Functions | |||
| Excel is rounding up my formula result | Excel Worksheet Functions | |||
| Rounding up the result of an IF function | Excel Worksheet Functions | |||
| Rounding a formula result to read thousands from millions. | Excel Worksheet Functions | |||
| Rounding up the result | Excel Worksheet Functions | |||
Linear Mode
