View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default interval formula

You probably want the Floor Function (see excel help).

Other usful function are
1) Int(number/300)
2) mod(number,300) gives the module remainder.

"xposedphotography" wrote:

In an excel spreadsheet I have a column that records usage hours for
machinery. I am curious if I could do an IF formula, or any other forumla
that would give an indicator for every 300 hour interval...300 600 900 etc.