| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding
How would I round (41,568.00) to (42,000.00)?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding
=CEILING(A1,1000)
-John "EC" wrote: How would I round (41,568.00) to (42,000.00)? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding
John,
Can the cell contain a formula? In other words, the cell has a formula in it that produces -41568.00. I tried your formula and I get the following error message: #NUM! I tried using just the value, and received the same error! Your help is really appreciated! Cheers. Eric "John Bundy" wrote: =CEILING(A1,1000) -John "EC" wrote: How would I round (41,568.00) to (42,000.00)? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding
The ceiling only works when both the number and the significance are the same
sign so you need to adjust the formula that John gave you as follows: =CEILING($A$5,SIGN(A5)*1000) Another way to do it is using the round function: =ROUND($A$5/1000,0)*1000 -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "EC" wrote: John, Can the cell contain a formula? In other words, the cell has a formula in it that produces -41568.00. I tried your formula and I get the following error message: #NUM! I tried using just the value, and received the same error! Your help is really appreciated! Cheers. Eric "John Bundy" wrote: =CEILING(A1,1000) -John "EC" wrote: How would I round (41,568.00) to (42,000.00)? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding
If just rounding to the nearest thousand then the simple answer is
=ROUND(A1,3) You can incorporate this in your existing formula if you wish by using =ROUND(your_formula,3) "Martin Fishlock" wrote: The ceiling only works when both the number and the significance are the same sign so you need to adjust the formula that John gave you as follows: =CEILING($A$5,SIGN(A5)*1000) Another way to do it is using the round function: =ROUND($A$5/1000,0)*1000 -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "EC" wrote: John, Can the cell contain a formula? In other words, the cell has a formula in it that produces -41568.00. I tried your formula and I get the following error message: #NUM! I tried using just the value, and received the same error! Your help is really appreciated! Cheers. Eric "John Bundy" wrote: =CEILING(A1,1000) -John "EC" wrote: How would I round (41,568.00) to (42,000.00)? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding
Sorry, of course that should be
=ROUND(A1,-3) "daddylonglegs" wrote: If just rounding to the nearest thousand then the simple answer is =ROUND(A1,3) You can incorporate this in your existing formula if you wish by using =ROUND(your_formula,3) "Martin Fishlock" wrote: The ceiling only works when both the number and the significance are the same sign so you need to adjust the formula that John gave you as follows: =CEILING($A$5,SIGN(A5)*1000) Another way to do it is using the round function: =ROUND($A$5/1000,0)*1000 -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "EC" wrote: John, Can the cell contain a formula? In other words, the cell has a formula in it that produces -41568.00. I tried your formula and I get the following error message: #NUM! I tried using just the value, and received the same error! Your help is really appreciated! Cheers. Eric "John Bundy" wrote: =CEILING(A1,1000) -John "EC" wrote: How would I round (41,568.00) to (42,000.00)? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding
It's amazing how I've never noticed that before.
Thanks for pointing it out. -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "daddylonglegs" wrote: Sorry, of course that should be =ROUND(A1,-3) "daddylonglegs" wrote: If just rounding to the nearest thousand then the simple answer is =ROUND(A1,3) You can incorporate this in your existing formula if you wish by using =ROUND(your_formula,3) "Martin Fishlock" wrote: The ceiling only works when both the number and the significance are the same sign so you need to adjust the formula that John gave you as follows: =CEILING($A$5,SIGN(A5)*1000) Another way to do it is using the round function: =ROUND($A$5/1000,0)*1000 -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "EC" wrote: John, Can the cell contain a formula? In other words, the cell has a formula in it that produces -41568.00. I tried your formula and I get the following error message: #NUM! I tried using just the value, and received the same error! Your help is really appreciated! Cheers. Eric "John Bundy" wrote: =CEILING(A1,1000) -John "EC" wrote: How would I round (41,568.00) to (42,000.00)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding | Excel Discussion (Misc queries) | |||
| How do I correct rounding errors in Excel formulas? | Excel Worksheet Functions | |||
| Rounding to the Nearest Eighth | Excel Discussion (Misc queries) | |||
| Rounding | Excel Discussion (Misc queries) | |||
| Banker's Rounding - need help! | Excel Discussion (Misc queries) | |||
Linear Mode
