Oops. I didn't read the question correctly. You want 1, not 100...etc.
The other options are better than.

WHAT AM I DOING WRONG? ...

You are trying to use 10 IF's, but you are running into the limit of 7 IF's
for Excel. Here's a copy from Help on "IF"
...."Up to seven IF functions can be nested as value_if_true and
value_if_false arguments to construct more elaborate tests."

Hope that explains the problem. ;)
--
Dana DeLouis
Win XP & Office 2003


"Trisha V via OfficeKB.com" wrote in message
...

thanks I tried that but it didnt work..

Dana DeLouis wrote:
Hi. How about
=FLOOR(A1,100)

Im working on a formula that looks somewhat like this:

[quoted text clipped - 7 lines]

WHAT AM I DOING WRONG? CAN SOMEONE PLEASE HELP ME?