OH my goodness, that's actually working...i do have a couple of questions
though. What is INT? and what does it stand for? and how come on the value
with $0 I get a negative number instead of 0?

Henry wrote:
Tricia,

How about
=INT((G9-1)/100)

Henry

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?