Is there a way to...

A

Arenlor

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?
 
P

Pete

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
 
H

Harlan Grove

Arenlor said:
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?
Click to expand...

=INT(E2/100)
 
Top