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

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?