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!

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

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

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

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

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