A worksheet formula?

=INT(A2/100)

--
HTH

Bob Phillips

"N.R." wrote in message
...
im trying to find out if a value in a cell is greater then 99 then it
should
say 1 if its greater then 199 then it should say 2 and so on and so on up
to
999

what im really trying to do is find out if i had a total of $325.35 what
increments i need such as hundreds fiftys twentys tens fives and so on if
any
one know that would be great if im dreaming well i guess im dreaming

thanks
N.R.