| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need more than 7 IF conditions...
I am trying to create a formula which will calculate the amount of time spent
on a project given the conditions of a standard workday. Essentially this just requires a conditional statement which takes into account a set lunch time (12:00 -12:30) and break time (10:00 - 10:20). I have created a formula to handle this over one workday, however when a project extends over more than one day the possibilities are expanded. In such circumstances I require more IF statements than excel will allow (7). Can anyone help with this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need more than 2 conditions in Conditional Formatting | Excel Worksheet Functions | |||
| Count using 2 conditions, one of which being a "less than or equal to" - URGENT | Excel Discussion (Misc queries) | |||
| COUNT using multiple conditions | Excel Discussion (Misc queries) | |||
| Formula for multiple conditions | Excel Discussion (Misc queries) | |||
| How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
Threaded Mode
