Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple If and Large functions in formula don't handle all circum
I have the following formula in a small table
=IF($D$380,IF($H$270,IF(E41=LARGE($E$41:$E$52,1) ,$D$38,0),IF(H41=LARGE($H$41:$H$52,1),$D$38,0)),0) The formula looks at D38 to see if there is overtime then it looks to H27 to see if there is hourly pay (there might not be due to all the pay from this week being Piecework...but overtime still needs to be calcualted if there are OT hours). If there is OT and there is hourly pay the formula looks int the table e41:e52 to determine the department with the most hours and asigns the OT to that department. If there is not any hourly pay the formula looks to the table in H41:H52 to see which department had the most piecework pay and allocates the OT to that department. The formula works GREAT with one minor flaw. If there are 2 or more departments tied for the most hours the OT gets incorrectly put to all of the departments that are tied. I can't think of an easy way to solve this and was hoping for some help. I welcome any thoughts, and thanks in advance if you can provide any help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How large can a file get before it is too big for Excel to handle? | Excel Discussion (Misc queries) | |||
need way to handle large csv imports that overflow cell size | Excel Discussion (Misc queries) | |||
Excel Beta 2007 on PC: unable to handle very large workbooks? | Excel Discussion (Misc queries) | |||
large formula question - Max nested functions | Excel Worksheet Functions |