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?