interval formula

  • Thread starter Thread starter xposedphotography
  • Start date Start date
X

xposedphotography

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.
 
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.
 
Back
Top