View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default Is there a way to...

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?