Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding up or down depending on number
Would anyone know a formula for the following?
What formula would round down if the tens of thousands in a number is less then 10,000.00 or round up if over 10,000.00? For example if cell A250 equals 506,789.90 the cell would read 506,000.00 but A250 equals 511,782.90 the cell would read 512,000? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding up or down depending on number
Surely the first one would round up also, to 507,000.00 ?
Try this: =ROUND(A1,-3) Hope this helps. Pete On Mar 26, 2:45*pm, JNAP101 wrote: Would anyone know a formula for the following? What formula would round down if the tens of thousands in a number is less then 10,000.00 or round up if over 10,000.00? For example if cell A250 equals 506,789.90 the cell would read 506,000.00 but A250 equals 511,782.90 the cell would read 512,000? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding up or down depending on number
Try this:
=ROUND(A250,-3) Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "JNAP101" wrote in message ... Would anyone know a formula for the following? What formula would round down if the tens of thousands in a number is less then 10,000.00 or round up if over 10,000.00? For example if cell A250 equals 506,789.90 the cell would read 506,000.00 but A250 equals 511,782.90 the cell would read 512,000? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding up or down depending on number
Hi Pete, Thanks for the quick response!! That's the problem if the
"thousands" is less than 10k they want the number to round down and round up if over 10.0k. I totally stuck on what formula would work. "Pete_UK" wrote: Surely the first one would round up also, to 507,000.00 ? Try this: =ROUND(A1,-3) Hope this helps. Pete On Mar 26, 2:45 pm, JNAP101 wrote: Would anyone know a formula for the following? What formula would round down if the tens of thousands in a number is less then 10,000.00 or round up if over 10,000.00? For example if cell A250 equals 506,789.90 the cell would read 506,000.00 but A250 equals 511,782.90 the cell would read 512,000? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding up or down depending on number
=IF(MOD(A250,100000)<10000,ROUNDDOWN(A250,-3),ROUNDUP(A250,-3))
-- David Biddulph "JNAP101" wrote in message ... Would anyone know a formula for the following? What formula would round down if the tens of thousands in a number is less then 10,000.00 or round up if over 10,000.00? For example if cell A250 equals 506,789.90 the cell would read 506,000.00 but A250 equals 511,782.90 the cell would read 512,000? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding up or down depending on number
Ah, I see what you mean now. David seems to have cracked it.
Pete On Mar 26, 3:08*pm, JNAP101 wrote: Hi Pete, Thanks for the quick response!! That's the problem if the "thousands" is less than 10k they want the number to round down and round up if over 10.0k. I totally stuck on what formula would work. "Pete_UK" wrote: Surely the first one would round up also, to 507,000.00 ? Try this: =ROUND(A1,-3) Hope this helps. Pete On Mar 26, 2:45 pm, JNAP101 wrote: Would anyone know a formula for the following? What formula would round down if the tens of thousands in a number is less then 10,000.00 or round up if over 10,000.00? For example if cell A250 equals 506,789.90 the cell would read 506,000.00 but A250 equals 511,782.90 the cell would read 512,000?- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional number depending on image name | Excel Discussion (Misc queries) | |||
Display number of day of month depending on the year | Excel Discussion (Misc queries) | |||
Function or number depending on input | Excel Worksheet Functions | |||
Copy a number from one cell to another depending on first number | Excel Worksheet Functions | |||
Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions |