Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Argument
I am new at creating formula in Excel. I am trying to create a specific
timesheet. The employee can work a maximum of 70 hours in 7 days. I have created this formula, which works for the pass 6 days but when I use it for 7 days, I have too many argument. I also have to create a formula for 13 days and 14 days (maximum of 120 hours). Works for pass 6 days: =IF(D25=0,"0",SUM(IF(D20=0,(D21:D25),IF(D21=0,(D22 :D25),IF(D22=0,(D23:D25),IF(D23=0,(D24:D25),IF(D24 =0,D25,IF(D20:D250,(D20:D25),"")))))))) Too many argument (7 days): =IF(D26=0,"0",SUM(IF(D20=0,(D21:D26),IF(D21=0,(D22 :D26),IF(D22=0,(D23:F26),IF(D23=0,(D24:D26),IF(D24 =0,(D25:D26),IF(D25=0,D26,IF(D20:D260,(D20:D26)," "))))))))) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If argument | Excel Worksheet Functions | |||
I Need An Argument | Excel Worksheet Functions | |||
what is an argument? | Excel Discussion (Misc queries) | |||
One more Argument. | Excel Worksheet Functions | |||
Function (array argument, range argument, string argument) vba | Excel Programming |