Thread: Is there a way to...
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
 
Posts: n/a
Default Is there a way to...
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?


Reply With QuoteReply With Quote