| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for rounding number to nearest hundred?
I'm new to excel and I've recently encountered a problem that's even
stumped my teacher. I'm hoping one of the whizes in this forum can help me: Say I have a number like 5413.3375, is there a formula to round it to the nearest hundred, which in this case would be 5400? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula for rounding number to nearest hundred?
How about =ROUND(B14,-2) - this assumes your number is in cell B14, of course.
Will "rinkjustice" wrote: I'm new to excel and I've recently encountered a problem that's even stumped my teacher. I'm hoping one of the whizes in this forum can help me: Say I have a number like 5413.3375, is there a formula to round it to the nearest hundred, which in this case would be 5400? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula for rounding number to nearest hundred?
I've tried that already roadkill. No go.
....thanks tho' roadkill wrote: How about =ROUND(B14,-2) - this assumes your number is in cell B14, of course. Will "rinkjustice" wrote: I'm new to excel and I've recently encountered a problem that's even stumped my teacher. I'm hoping one of the whizes in this forum can help me: Say I have a number like 5413.3375, is there a formula to round it to the nearest hundred, which in this case would be 5400? Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula for rounding number to nearest hundred?
roadkill's suggestion is perfect. Either you are doing something wrong, or
there is something wrong with your Excel installation. When you enter his ROUND formula, what does it return? BTW, here is another way to accomplish the same goal: =(INT(B14/100)*100) Hope this helps, Hutch "rinkjustice" wrote: I've tried that already roadkill. No go. ....thanks tho' roadkill wrote: How about =ROUND(B14,-2) - this assumes your number is in cell B14, of course. Will "rinkjustice" wrote: I'm new to excel and I've recently encountered a problem that's even stumped my teacher. I'm hoping one of the whizes in this forum can help me: Say I have a number like 5413.3375, is there a formula to round it to the nearest hundred, which in this case would be 5400? Thanks! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula for rounding number to nearest hundred?
Eureka! You've got it Hutch! The other function returned a #NAME! error
at me (in OpenOffice). I forget what it did in Excel. Thanks very much to everyone. Tom Hutchins wrote: roadkill's suggestion is perfect. Either you are doing something wrong, or there is something wrong with your Excel installation. When you enter his ROUND formula, what does it return? BTW, here is another way to accomplish the same goal: =(INT(B14/100)*100) Hope this helps, Hutch "rinkjustice" wrote: I've tried that already roadkill. No go. ....thanks tho' roadkill wrote: How about =ROUND(B14,-2) - this assumes your number is in cell B14, of course. Will "rinkjustice" wrote: I'm new to excel and I've recently encountered a problem that's even stumped my teacher. I'm hoping one of the whizes in this forum can help me: Say I have a number like 5413.3375, is there a formula to round it to the nearest hundred, which in this case would be 5400? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
| If formula | Excel Worksheet Functions | |||
| Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
| Looking for function or formula to calculate number that is revers | Excel Worksheet Functions | |||
| How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) | |||
Linear Mode
