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?
"rinkjustice" wrote in message
oups.com... 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! =ROUND(A1,-2) You may need to teach your teacher how to use Excel's Help facility. -- David Biddulph |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for rounding number to nearest hundred?
It didn't work on Excel back at the learning center, and it's not
working now in OpenOffice Calc (which I've found full featured and almost identical to Excel). If that is indeed the formula, tell me what I've been doing wrong. David Biddulph wrote: "rinkjustice" wrote in message oups.com... 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! =ROUND(A1,-2) You may need to teach your teacher how to use Excel's Help facility. -- David Biddulph |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for rounding number to nearest hundred?
"rinkjustice" wrote in message
ups.com... David Biddulph wrote: "rinkjustice" wrote in message oups.com... 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! =ROUND(A1,-2) It didn't work on Excel back at the learning center, and it's not working now in OpenOffice Calc (which I've found full featured and almost identical to Excel). If that is indeed the formula, tell me what I've been doing wrong. Give us a clue? You tell us what result you're getting, and then we'll try to tell you what you are doing wrong. In the meantime it works for me in Excel 2003 and in Open Office 2.0.1. Did you type the formula in correctly, or copy and paste to your sheet? Are you sure you've pointed the formula at the cell where the data is? Failing all that, are you sure that your source cell (where the 5413.3375 is) is formatted as a number, and doesn't have spare characters that might be causing it to be treated as text? [If you're not sure, try ISNUMBER(A1) and ISTEXT(A1).] -- David Biddulph |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for rounding number to nearest hundred?
I must've typed it in wrong before, because at school both formulas
worked today (and they're using Excel 2003). As for OpenOffice Calc at home (where roadkill's formula mysteriously fails), ISNUMBER(A1) returned TRUE and ISTEXT(A1) returned FALSE. Any ideas? David Biddulph wrote: "rinkjustice" wrote in message ups.com... David Biddulph wrote: "rinkjustice" wrote in message oups.com... 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! =ROUND(A1,-2) It didn't work on Excel back at the learning center, and it's not working now in OpenOffice Calc (which I've found full featured and almost identical to Excel). If that is indeed the formula, tell me what I've been doing wrong. Give us a clue? You tell us what result you're getting, and then we'll try to tell you what you are doing wrong. In the meantime it works for me in Excel 2003 and in Open Office 2.0.1. Did you type the formula in correctly, or copy and paste to your sheet? Are you sure you've pointed the formula at the cell where the data is? Failing all that, are you sure that your source cell (where the 5413.3375 is) is formatted as a number, and doesn't have spare characters that might be causing it to be treated as text? [If you're not sure, try ISNUMBER(A1) and ISTEXT(A1).] -- David Biddulph |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for rounding number to nearest hundred?
"rinkjustice" wrote in message
oups.com... David Biddulph wrote: "rinkjustice" wrote in message ups.com... David Biddulph wrote: "rinkjustice" wrote in message oups.com... 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! =ROUND(A1,-2) It didn't work on Excel back at the learning center, and it's not working now in OpenOffice Calc (which I've found full featured and almost identical to Excel). If that is indeed the formula, tell me what I've been doing wrong. Give us a clue? You tell us what result you're getting, and then we'll try to tell you what you are doing wrong. In the meantime it works for me in Excel 2003 and in Open Office 2.0.1. Did you type the formula in correctly, or copy and paste to your sheet? Are you sure you've pointed the formula at the cell where the data is? Failing all that, are you sure that your source cell (where the 5413.3375 is) is formatted as a number, and doesn't have spare characters that might be causing it to be treated as text? [If you're not sure, try ISNUMBER(A1) and ISTEXT(A1).] I must've typed it in wrong before, because at school both formulas worked today (and they're using Excel 2003). As for OpenOffice Calc at home (where roadkill's formula mysteriously fails), ISNUMBER(A1) returned TRUE and ISTEXT(A1) returned FALSE. Any ideas? Glad to hear that it works. It's usually safest to copy the formula from the newsgroup into your Excel sheet, as that cuts out the risk of typing errors. As for your problem in Open Office, as a number of us have already said, if you tell us what result you're getting then it'll be a lot more likely that someone will be able to tell you what you've done wrong. We're not psychic, although some of the cleverer subscribers to the group may give that impression. Look again at the questions I asked in my previous post above. -- David Biddulph |
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) |