| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple comparisons in a cell
I'm still learning what Excel 2003 can do for me, so this may be a stupid
question. I am tracking equipment maintenance records and I need to create a cell that will say "OK" if the machine has over a certain of hours since the last maintenance, "DUE NOW" if it is within 300 hours, and "LATE" if I'm under 50 hours. I've gotten it to work with 2 conditions, but don't know how to get it to do 3. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Yr to Yr comparisons | Excel Discussion (Misc queries) | |||
| Can I make multiple comparisons ? | Excel Discussion (Misc queries) | |||
| Multiply IF AND OR comparisons | Excel Worksheet Functions | |||
| Spreadsheet Comparisons | Excel Discussion (Misc queries) | |||
| Multiple column comparisons | Excel Discussion (Misc queries) | |||
Threaded Mode
