What I have set up is this =E2/100 in cell D2, what I want to know is, is
there any way to have it only go up 1 every time E2 reaches another hundred
instead of going up by .01 each time E2 goes up by one?

Maybe use this instead.....

=ROUNDDOWN(E2/100,0)

Vaya con Dios,
Chuck, CABGx3


"Arenlor" wrote in message
...
What I have set up is this =E2/100 in cell D2, what I want to know is, is
there any way to have it only go up 1 every time E2 reaches another
hundred
instead of going up by .01 each time E2 goes up by one?

Yes, make the formula

=ROUND(E2/100,0)

This will show integers, so if E2 = 50 to 149 it will return 1, if E2
is 150 to 249 it will show 2, etc. Is this what you want? (or do you
want it to show 1 only when E2 is 100 to 199 ?)

Pete

Arenlor,

Try:

=INT(E3/100)

--
HTH

Sandy

with @tiscali.co.uk

"Arenlor" wrote in message
...
What I have set up is this =E2/100 in cell D2, what I want to know is, is
there any way to have it only go up 1 every time E2 reaches another
hundred
instead of going up by .01 each time E2 goes up by one?

"Arenlor" wrote...
What I have set up is this =E2/100 in cell D2, what I want to know is, is
there any way to have it only go up 1 every time E2 reaches another hundred
instead of going up by .01 each time E2 goes up by one?

=INT(E2/100)