| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can i round a dollar amount to the nearest thousand?
I'm trying to set up a spreadsheet and one of my columns I want to have
rounded to the nearest dollar amount. I want, if the amount is 18575.00 to round to 19000.00 and if the amount is 18475.00 to round to 18000.00. How can I do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how can i round a dollar amount to the nearest thousand?
karen wrote:
I'm trying to set up a spreadsheet and one of my columns I want to have rounded to the nearest dollar amount. I want, if the amount is 18575.00 to round to 19000.00 and if the amount is 18475.00 to round to 18000.00. How can I do this? =round(A1, -3) where A1 contains the dollar amount. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I round a number to the nearest thousand in Excel??? | Excel Discussion (Misc queries) | |||
| Format Round to Nearest Thousand | Excel Discussion (Misc queries) | |||
| Round to nearest thousand | Excel Discussion (Misc queries) | |||
| What is the formula for rounding a dollar amount to the nearest ni | New Users to Excel | |||
| WHATS AN EASY FUNCTION TO USE TO ROUND TO THE NEAREST THOUSAND? | Excel Worksheet Functions | |||
Linear Mode
