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