Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
interval formula
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Repeat a formula with interval | Excel Worksheet Functions | |||
Repeat a formula with interval | Excel Worksheet Functions | |||
Formula used by Excel to determine y-axis interval in chart | Excel Discussion (Misc queries) | |||
Confidence Interval | Excel Worksheet Functions | |||
interpolation in a particular interval (HELP) | Excel Discussion (Misc queries) |