if greater then 99 then 1 if greater then 199 then two
 

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.

If your # is in cell A1, here's the answer

=IF(MOD(A1,100)=99,1+INT(A1/100),INT(A1/100))

I'm assuming your numbers are 199 as opposed to 1.99 which may not be a
valid assumption.

There are a lot of answers to the 2nd part, but I'd have to think about it
in EXCEL.

"N.R." wrote:

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.

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.